Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: print out structure of pl/sql record

Re: print out structure of pl/sql record

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Thu, 20 May 2004 16:15:32 -0700
Message-ID: <1085094937.723200@yasure>


spliffy wrote:

> Hi,
>
> I'd like to query the database for the definition of a user defined
> pl/sql record (i.e. print out the record's fields, and their type).
> You'd think describe would do it, but it's doesn't work with pl/sql
> records.
> So does anyone know how to do this from sqlplus?
> Note, it must be done by querying the database, and not parsing text
> files.
>
> Kind regards

If I had a clue what you mean by "a user defined pl/sql record" because users don't, and can't, define PL/SQL records.

Can you better explain what you mean?

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Thu May 20 2004 - 18:15:32 CDT

Original text of this message

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