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).