On Nov 7, 4:49 pm, Jake <jgarfi..._at_earthlink.net> wrote:
> With cursors I could define a lot of my queries in the package
> specification. This is a convenient way to put queries in one place.
> The parameterized cursor idea is nice too. Plus it helps in not
> writing the same query many times throughout the code.
>
> What if I would like to do a similar thing, but I need to use REF
> CURSORS strictly for the ability to be able to pass the ref cursor to
> a procedure. What's the preferred way of defining queries when using
> REF CURSORS if I wanted to have a similar effect?
>
> For example: Would it be feasible to define many VARCHAR2s that
> represent queries in one package? Or is there a way to associate REF
> CURSORS with a regular cursor that's defined in a package?
>
> What would be the preferred way to do this?
>
> thanks.
One approach might be to define packaged functions that returned ref
cursors.
Received on Fri Nov 09 2007 - 02:35:21 CST
