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

sql plus> exec Package.functionname

Bill wrote:

> 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 Mon Apr 02 2001 - 06:58:31 CDT