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

From: <adamvt_at_my-deja.com>
Date: Mon, 20 Nov 2000 17:10:39 GMT
Message-ID: <8vblu8$ji4$1@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 - 11:10:39 CST