procedure example 3

-- procedure which find out maximum salary from emp1 table.
CREATE OR REPLACE PROCEDURE prc_max_sal(s OUT NUMBER)
IS
BEGIN
    SELECT MAX(salary) INTO s
    FROM emp1;
END prc_max_sal;
/

DECLARE
    s NUMBER;
BEGIN
    prc_max_sal(s);
    DBMS_OUTPUT.put_line(s);
END;
/