Re: REF cursors vs. cursors

Jake 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.

Strongly or weakly typed?

If weakly typed just use sys_refcursor and be done with it.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org