Bill, A PL/SQL Table of <MyTable>%RowType can be returned from a function or as an Out Argument from a procedure.
A Ref Cursor (Cursor Variable) can also be returned as an Out Argument from a procedure. See the PL/SQL Users Guide and Reference for info. on these. Jack -------------------------------- Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -----Original Message----- Bill Sent: Tuesday, March 19, 2002 7:58 AM To: Multiple recipients of list ORACLE-L Hi, Is there a way to write a procedure to return multiple rows? I have some nasty SQL that I'd like to convert to run server-side, but how do you spit out multiple rows from PL/SQL? thx Bill Magaliff Framework, Inc. 914-631-2322 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite 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).