Live ORACLE

CREATE OR REPLACE PACKAGE emp_data

AS

  TYPE empcurtyp IS REF CURSOR RETURN employees%ROWTYPE;

 

  PROCEDURE open_emp_cv(emp_cv  IN OUT EMPCURTYP);

END emp_data;

/


CREATE OR REPLACE PACKAGE BODY emp_data

AS

  PROCEDURE Open_emp_cv

       (emp_cv  IN OUT EMPCURTYP)

  IS

  BEGIN

    OPEN emp_cv FOR

      SELECT *

      FROM   employees;

  END open_emp_cv;

END emp_data;

/

Stored Procedure to Open a Ref Cursor