PL/SQL newbie question

[Rick Silvers]

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