CREATE OR REPLACE PROCEDURE p_get (
   p_empno         NUMBER,
   p_name    OUT   VARCHAR2,
   p_sal     OUT   NUMBER,
   p_job     OUT   VARCHAR2
)
IS
BEGIN
   SELECT ename, sal, job
     INTO p_name, p_sal, p_job
     FROM emp
    WHERE empno = p_empno;
END;

declare
p_name varchar2(20);
p_sal number;
p_job varchar2(20);
begin
p_get(7369,p_name,p_sal,p_job);
dbms_output.put_line('Name='||p_name||' Salary='||p_sal||' Job='||p_job);
end;

-- Positional Notation.
p_get(7369,p_name,p_sal,p_job);

-- Mixed Notation.
p_get(p_empno => 7369,p_name,p_sal,p_job);

-- Named Notation.
p_get(p_empno => 7369,p_name => p_name,p_sal => p_sal,p_job => p_job);