--  create GetEmployeeDetails Stored Procedure
create or replace procedure GetEmployeeDetails
    ( emp_id in number,fname out varchar2, job out varchar2)
 as
 begin
    select emp.ename, emp.job
      into fname, job 
      from emp
      where 
        emp.empno = emp_id;
 exception
    when no_data_found then
     fname := 'Unknown';
     job := 'Unknown';
     end;