Newbie: how to excecute sp and package with result sets.

Could anyone kindly brief me how to execute the package and stored procedure.

My code is :-

PACKAGE TEST1
IS
TYPE OUTPARM123 IS REF CURSOR;
END; PACKAGE BODY TEST1
AS
TYPE OUTCUR IS REF CURSOR;
  PROCEDURE RETURNDATA(O_CURSOR OUT OUTCUR)   AS
  BEGIN
   OPEN O_CURSOR FOR SELECT * FROM EQUIPMENT;   END;
BEGIN
NULL;
END; I've created another SP with code:-

AS
CURSOR TMP IS (SELECT * FROM EQUIPMENT); BEGIN
OPEN TMP;
END; Thanks a lot

Regards,

Billy
laukw_at_ha.org.hk Received on Sun Mar 25 2001 - 04:01:58 CST