Re: Too Many Cursors?

Mark D Powell wrote:
> Helge, you comment that another table is involved in the join indicates
> that you are not showing the real query. Removing excess columns is
> fine but I think to provide valid advice board readers need to see the
> real join conditions. Where is the explain plan for the query? Have
> you tried replacing the 0 = subquery with a not exists subquery?

My mistake. I shouldn't even have posted the first version of the query if I didn't want you all to worry about it. Sorry about that.

What I'm really after is help figuring out how to get a function to return a ref cursor without complaining that I've got too many cursors open. I sort of assumed that a cursor is closed automatically when it goes out of scope, but maybe that isn't right?

--
 Helge Moulding
 hmoulding at gmail dot com                 Just another guy
 http://hmoulding.cjb.net/                  with a weird name