hi Andrew,

consider using a array (pl/sql table) as a return
datatype of your function. Inside the function open ur
cursor and populate that set of rows u wanna return
into the return datatype.. which would be an array in
this case. note that u must define a global array in
some package first so that u could thereafter define
and start using the array as a return datatype of ur
function.

if all the above sounds mumbo jumbo to u then let me
know .. i will send e.g. 2 u next time;)

hth
deepak



--- Andrey Bronfin <[EMAIL PROTECTED]> wrote:
> 
> Dear DBAs !
> I need to write a stored proc that will do the
> following : 
> -- open a cursor ; 
> -- loop over the rows returned by the cursor , 
>       filter out some of the rows that do not match 
> a certain criteria  , 
>       do some processing on other rows (that match 
> the criteria) 
>       and then return those rows (the processed
> data) to the calling program
> ( a PERL DBI script or a java program ) .
> Ho do U return those multiple rows to a calling
> program ?
> It's Oracle 8.0.5 , NOT 8i :-( 
> 
> Thanks a lot in advance,
> DBAndrey
> 
> * 03-9254520
> * 053-464562
> * mailto:[EMAIL PROTECTED]
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Andrey Bronfin
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services    -- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California        -- Public Internet
> access / Mailing Lists
>
--------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).


__________________________________________________
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Reply via email to