Re: PL/SQL procedure to return multiple rows

From: Deepak Thapliyal <deepakthapliyal_at_yahoo.com>
Date: Sun, 16 Sep 2001 12:17:36 -0700
Message-ID: <F001.0038FE27.20010916122017@fatcity.com>

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 <andreyb_at_elrontelesoft.com> 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:andreyb_at_elrontelesoft.com
  >
  >
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author: Andrey Bronfin
  > INET: andreyb_at_elrontelesoft.com
  >
  > 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: ListGuru_at_fatcity.com (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: deepakthapliyal_at_yahoo.com

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: ListGuru_at_fatcity.com (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).

Received on Sun Sep 16 2001 - 14:17:36 CDT