Re: how to pass a resultset out of a store procedure

Hi,

In the package body, how would one use the defined REF Cursor?

Would it be somthing like..
lo_CursorSet := Select * from table;

Scott

"M Hashim" <mhashim_ca_at_passport.ca> wrote in message news:3A8A07F1.AA68541C_at_passport.ca...
> Put it in a package
>
> TYPE OutParm??? IS REF CURSOR;
>
> CREATE OR REPLACE PACKAGE BODY ReturningCursorDataSet AS
> TYPE OutParmCursorType IS REF CURSOR;
> PROCEDURE ProcReturningCursorDataSet( o_CursorSet OUT
 OutParmCursorType)
> AS
> etc....
>
> OR
> return it from a function.....
>
>
>
> Surti wrote:
>
> > If i want to write a statement "select * from abc" (which returns
 multiple
> > records with multiple fields) then how can i pass this resultset to me
 front
> > end. the output parameters won't work here as I need to pass out
 multiple
> > records
> >
> > Any help will be appreciated
>
Received on Thu Feb 15 2001 - 21:09:38 CST