Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL newbie question
"Rick Silvers" <rsilvers_at_mebtel.net> wrote in
news:d3uns001lgr_at_enews4.newsguy.com:
> 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
>
>
>
I can't say that I am impressed with your "design". Visit http://asktom.oracle.com & do some keyword searches. The site is maintained by Tom Kyte; a real Oracle GURU!
Also you can find the whole collection of Oracle documentation at
http://tahiti.oracle.com
There you might want to look at the Concepts manual, the one for
PL/SQL reference & the Developer's guide.
HTH & YMMV Received on Sun Apr 17 2005 - 18:14:12 CDT