AFAIK there are no PL/SQL functions to do what you want to do; they are available as
OCI functions, though, but PL/SQL only implements a very small subset of what is
available with OCI. An external C procedure might be an option, but only if not called
too often.
In my experience trying to
Thats what XML is for :P
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of A
Joshi
Sent: Sunday, January 25, 2004
10:19 PM
To: Multiple recipients of list
ORACLE-L
Subject: ** field names of a ref
cursor
Hi,
I am calling a Oracle stored
26, 2004 1:19
AMTo: Multiple recipients of list ORACLE-LSubject: **
field names of a ref cursor
Hi,
I am calling a Oracle stored procedure which has a ref cursor as a
out param. I get the values. Is there a way for me to know the field names and
type of the fields being passed
Joshi, you'll have to use DBMS_SQL and return number instead of ref
cursor. DBMS_SQL has its own, internal table describing open cursors
by numbers. DBMS_SQL also contains a procedure called describe which,
I believe, does exactly what you want without XML or OCI.
On 01/26/2004 01:19:27 AM, A
Hi,
I am calling a Oracle stored procedure which has a ref cursor as a out param. I get the values. Is there a way for me to know the field names and type of the fields being passed in the ref cursor. Basically when the procedure sends back the ref cursor what information do I get apart from the
