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 -> Re: How to view PL/SQL code for a procedure?

Re: How to view PL/SQL code for a procedure?

From: joel garry <joel-garry_at_home.com>
Date: 25 Jul 2006 13:37:46 -0700
Message-ID: <1153859866.670160.227650@b28g2000cwb.googlegroups.com>

DA Morgan wrote:
> Sameer wrote:
> > Hello,
> > I am using Oracle 8i. I have created several procedure in the database.
> > Once they are created, they are part of database.
> > This is being part of Oracle Data Dictionary, be stored in one of the
> > table.
> > Can we see the code of these procedures?
> > I know that it is possible using tool like SQL Developer or Toad, but
> > how to do this in SQL * Plus?
> > Please help.
> > -Sameer
>
> The best method with any Oracle object is:
>
> SELECT dbms_metadata.get_ddl('<object_type>', '<object_name>')
> FROM dual.
>
> This package is documented at http://tahiti.oracle.com and as
> $ORACLE_HOME/rdbms/admin/dbmsmeta.sql.

A 9i new feature, so not for the OP.
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/whatsnew.htm#970843

Sameer:

8i is obsolete, only marginally supported by Oracle if you've kept up your support contract.

jg

--
@home.com is bogus.
Cure AIDS, diabetes and cancer!
http://www.signonsandiego.com/uniontrib/20060725/news_1b25ftc.html
Received on Tue Jul 25 2006 - 15:37:46 CDT

Original text of this message

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