create or replace
package GestionEmployes as
type ENREMPLOYE is REF CURSOR;

PROCEDURE INSERTION (NumEmp IN NUMBER , NomEmp IN VARCHAR2 ,PrenomEmp2 IN VARCHAR2, SalaireEmp IN NUMBER, EmploiEmp varchar2);

PROCEDURE RECHERCHE (Nom in varchar2, Temporaire out ENREMPLOYE);

PROCEDURE SUPPRIMER (NumEmp in number);

PROCEDURE METTREAJOUR (NumEmp IN NUMBER , NomEmp IN VARCHAR2 ,PrenomEmp2 IN VARCHAR2, SalaireEmp IN NUMBER, EmploiEmp varchar2);

FUNCTION TOTAL RETURN NUMBER;

end;