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";
...