Re: PL/SQL newbie question

Rick,

create a master procedure which includes the cursor, call the cursor and then call the other procedures from within that master procedure

David
djwilkes_at_hotmail.com

"Rick Silvers" <rsilvers_at_mebtel.net> wrote in message news:d3unu901lht_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
>
>
Received on Tue Apr 19 2005 - 11:43:27 CEST