Live ORACLE

CREATE OR REPLACE PACKAGE emp_data

AS

  TYPE empcurtyp IS REF CURSOR RETURN employees%ROWTYPE;

 

  -- emp_cv EmpCurTyp; -- not allowed

  PROCEDURE open_emp_cv;

END emp_data;

/


CREATE OR REPLACE PACKAGE BODY emp_data

AS

  -- emp_cv EmpCurTyp; -- not allowed

  PROCEDURE Open_emp_cv

  IS

    emp_cv  EMPCURTYP; -- this is legal

 

  BEGIN

    OPEN emp_cv FOR

      SELECT *

      FROM   employees;

  END open_emp_cv;

END emp_data;

/

Declaration of Cursor Variables in a Package