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.desc_rec type

dbms_sql.desc_rec type

From: Michael Rothwell <marothwell_at_yahoo.com>
Date: Fri, 21 Jan 2000 10:24:17 -0800
Message-ID: <3888A451.1ACDA319@yahoo.com>


I use the following code in 8i to return a column header for free form queries supplied to a stored proc. I just found out that it doesn't work for 7.3.4. Is there any work-around for this functionallity?

function ShowColName(rec in dbms_sql.desc_rec) return varchar2 is begin
  return rec.col_name ;
end;

Thanks.

Michael Received on Fri Jan 21 2000 - 12:24:17 CST

Original text of this message

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