Oracle Function call - 12C
create or replace procedure foo(empId IN NUMBER, maxSalary OUT NUMBER) AS q SYS_REFCURSOR; BEGIN OPEN q FOR select * from Employee e where e.id >=empId; DBMS_SQL.return_result (q); -- This will display the result select max(salary) into maxSalary from Employee; END;
Source: stackoverflow.com