Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Obtaining a ref cursor from a table object

Re: Obtaining a ref cursor from a table object

From: Noons <wizofoz2k_at_yahoo.com.au.nospam>
Date: Thu, 19 Jun 2003 17:40:04 +1000
Message-ID: <3ef1693a$0$31550$afc38c87@news.optusnet.com.au>


"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.nospam
Received on Thu Jun 19 2003 - 02:40:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US