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: dbms_sql and ref cursor?

Re: dbms_sql and ref cursor?

From: Mark Tomlinson <marktoml_at_hotmail.com>
Date: Thu, 27 Jan 2000 19:39:41 -0500
Message-ID: <s91p2t217q5100@corp.supernews.com>


No, but you can with later versions of the RDBMS.

"Werner Ebert" <ebert_at_zv.fhg.de> wrote in message news:38907932.79401C57_at_zv.fhg.de...
>
> I'd like to dynamically create a statement within a package function
> and return the resultset to the caller.
>
> Is there a way of getting a ref cursor from a dynamic sql statement
> created with dbms_sql in Oracle 7.3 ?
>
> Or is there any other way to do this in Oracle 7.3 ?
>
> Any hint would be appreciated.
>
>
> Werner Ebert
>
>
Received on Thu Jan 27 2000 - 18:39:41 CST

Original text of this message

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