Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Obtaining a ref cursor from a table object
"Teppicamon" <quicog_at_hotmail.com> wrote in message
news:bcpj55$l2p9o$1_at_ID-162849.news.dfncis.de...
> >
> > unless i'm mistaken, i think that the OP knows how to return ref
> > cursors--what he's essentially asking here is, can you return the
> > contents of a PL/SQL table (namely, one of type CTX_THES.EXP_TAB) as a
> > ref cursor. and afaik, the answer is, not really.
>
> Yep, that's actually the point... Anyway, thank you Nuno for your help...
> --
No worries. IIRC, you can use PL/SQL tables directly in SQL in 9i, it's somewhere in the PL/SQL manual. You know, CAST and all that stuff. But you are in 8.1.7, so asktom is your best bet.
-- Cheers Nuno Souto wizofoz2k_at_yahoo.com.au.nospamReceived on Thu Jun 19 2003 - 02:40:04 CDT