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 "" 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@Yahoo.com #