Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: dbms_sql and ref cursor?
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