Re: PL/SQL newbie question

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Sun, 17 Apr 2005 23:15:01 GMT
Message-ID: <Xns963BA54EA58D7SunnySD_at_68.6.19.6>


"Rick Silvers" <rsilvers_at_mebtel.net> wrote in 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
>
>
>

[Quoted] DON"T cross post! Received on Mon Apr 18 2005 - 01:15:01 CEST

Original text of this message