Re: retun cursor

Stephan Szabo wrote:
>
> On Thu, 6 Apr 2000, Madhavi Daroor wrote:
>
> > Hi,
> > I have tried the method you have suggested. And everytime I try to access
> > the function in which the refcursor is kept open, the only output I get is
> > "UNNAMED CURSOR" instead of the selected fields in the cursor.
>
> Right. You get a cursor name that you can fetch from, if you're in a
> transaction, after you select from the function, say it returns
> "unnamed cursor 1", IIRC you can do,
>
> fetch 10 from "unnamed cursor 1";

Should be "<unnamed cursor 1>" if memory serves.

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #