create or replace procedure empproc1(empid in number,
empname out varchar2)
is
begin
select ename into empname from empinout where empid = empno;
end;
/
