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

From: <adamvt_at_my-deja.com>
Date: Mon, 20 Nov 2000 17:12:02 GMT
Message-ID: <8vbm0r$jjb$1_at_nnrp1.deja.com>


Thanks for your reply Helmut!

But my main point was to built a view on it.

Thanks,
Adam.
In article <3A18DEB5.ECD00638_at_bitoek.uni-bayreuth.de>,   Helmut Hahn <helmut.hahn_at_bitoek.uni-bayreuth.de> wrote:
> > ...
> > 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
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Nov 20 2000 - 18:12:02 CET

Original text of this message