create or replace package emp_pack as
function get_name(empno int)return varchar2;
end emp_pack;                                                     
/
create or replace package body emp_pack as
function get_name(empno int)return varchar2
as                                                      
fname varchar2(20);
lname varchar2(20);
Begin                                                                                  
Select first_name, last_name into fname,lname from employees
where employee_id=empno;                                                                     
return (fname||' ' ||lname);                                                                                 
end get_name;                                                                                      
end emp_pack;
/

