Re: Select from a REF CURSOR

From: VC <boston103_at_hotmail.com>
Date: Fri, 07 Nov 2003 23:47:46 GMT
Message-ID: <CaWqb.140707$Tr4.363219@attbi_s03>

Paul,

I am sorry to say but the way you already knew about is the only one to use the REF CURSOR in a select statement.

Rgds.

"Paul Moore" <pf_moore_at_yahoo.co.uk> wrote in message news:fzgzg2yd.fsf_at_yahoo.co.uk...
> "VC" <boston103_at_hotmail.com> writes:
>
> > Hello Paul,
> >
> > Here's an example:
> >
> > create or replace type myType as object (
> [...]
>
> Thanks for this, but I already knew this approach. What I'm looking
> for is a way to cast a returned REF CURSOR (not an object table) into
> a table suitable for a FROM clause.
>
> See my other followup for a bit more detail...
>
> Paul
> --
> This signature intentionally left blank
Received on Fri Nov 07 2003 - 17:47:46 CST