procedure
===========
CREATE OR REPLACE PROCEDURE PROC1(NUM NUMBER,NAME OUT VARCHAR)
IS
BEGIN
SELECT ENAME INTO NAME FROM EMP WHERE EMPNO=NUM;
END;
------------
execution
-------------------
declare
n varchar2(10);
begin
proc1(7788,n);
dbms_output.put_line(n);
end;