Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> PL/SQL newbie question
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 Received on Sun Apr 17 2005 - 17:28:07 CDT