Re: Too Many Cursors?

Billy wrote:
> The ref cursor struct and resources are only released when the session
> owning that ref cursor pointer terminates, or when the ref cursor is
> explicitly closed (e.g. using the PL/SQL call CLOSE).

Thanks, Billy. So what I was trying to do is a generally bad idea? Is there a way that a function can return several columns at once, without using a ref cursor? I looked at a piped function, but it seemed as if that would get me no advantage over just selecting from the joined tables.

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