REF cursors vs. cursors

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. Received on Wed Nov 07 2007 - 10:49:56 CST