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

No
OPEN <ref cursor var > FOR
<select statement>
as described in the pl/sql manual.
If you don't have it, it's online at http://technet.oracle.com Steven Feuersteins book on PL/SQL is also a good source for examples.

Hth,

Sybrand Bakker, Oracle DBA

In article <SR0j6.170$lx.198074_at_typhoon2.ba-dsg.net>, "Scott says...
>
>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 Tue Feb 20 2001 - 11:40:09 CET