Re: How to use ref curs function in a SELECT or VIEW?

> ...
> Now can I do something like this which of course did not work for me:
>
> select refCur3.GetMgrData(7369) from dual;
>
> I mean a similar concept which will work? I know I can get a
> concatenated result from the function then parse it, but I would like
> to know if it is possible with a "Ref curs" function.

Try

variable x refCursor
set autoprint on
execute refCur3.GetMgrData(7369)

>
>
> Thanks,
> Adam.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Helmut Received on Mon Nov 20 2000 - 02:20:05 CST