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
Title: Message
If you
are using strongly typed ref cursors, I believe you can use the DBMS_DESCRIBE
package to get that information. You'll just have to parse the output from the
package.
Kevin
-Original Message-From: A Joshi
[mailto:[EMAIL PROTECTED] Sent: Monday, January
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