Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL newbie question

Re: PL/SQL newbie question

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Sun, 17 Apr 2005 23:04:51 -0700
Message-ID: <1113804066.722064@yasure>


Rick Silvers wrote:
> Hello All,
>
> I am new to PL/SQL, come from a COBOL/DB2/iSeries world. I have a question
> about Packages, Procedures.
> I want to create a Package, that will have several Procedures and will have
> a CURSOR declared in the Package
> which can be opened and fetched and passed to all the procedures in the
> package. The select statement in the cursor
> returns 50 rows. I need to be able to loop thru and pass each fetched row to
> the procedures in the Package.
>
> Can someone share an example on how to do this ?
>
> Thanks,
>
> Rick Silvers

Assuming Oracle 9i or later you should be using bulk collection ... not a cursor.

Look at the links suggested by IANAL_VISTA but also look at: http://www.psoug.org
click on Morgan's Library
click on Bulk Binding

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Mon Apr 18 2005 - 01:04:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US