Hi,

How can i retrive multiple results from oracle store procedure.i have tried with using package but it giving err shown below

ORA-06550: line 2, column 15:
PLS-00201: identifier 'CURSOR' must be declared
ORA-06550: line 2, column 11:
PL/SQL: Item ignored.

First i create package shown below

CREATE PACKAGE test12
IS
TYPE CursorType IS REF CURSOR;
END test12;

create procedure shown below
PROCEDURE RESULT_SET
(oCursor IN OUT test12.CursorType) AS
BEGIN
open oCursor for select * from testab;
END;

when i exec this procedure on sqlplus exec result_set( );

getting error occur shown below

ORA-06550: line 2, column 15:
PLS-00201: identifier 'CURSOR' must be declared

Please anybody can help me this issue.