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

dbms_sql and ref cursor?

From: Werner Ebert <ebert_at_zv.fhg.de>
Date: Thu, 27 Jan 2000 17:58:26 +0100
Message-ID: <38907932.79401C57@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 - 10:58:26 CST

Original text of this message

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