-- These stored procedures assume that you have already run DEMOBLD.SQL


create or replace package Employee as

 procedure GetEmpName (inEmpno IN varchar2, outEmpName OUT varchar2);

end Employee;
/


create or replace package body Employee as

procedure GetEmpName (inEmpno IN varchar2, outEmpName OUT varchar2) is 
begin 
 SELECT ENAME into outEmpName from EMP WHERE EMPNO = inEmpNo;
end;

end Employee;
/

