Re: Where is the sql stored for a stored procedure?

It is also a good idea to include the type or you can end up with such confusing things as the text of a package mixed with the text of the package body.

                        Pat

>
> SELECT TEXT
> FROM DBA_SOURCE
> WHERE NAME = 'object_name'
> and owner='owner name'
> order by line
>
> just in case two people own objects with the same name. And while it
> MIGHT do the select in line order, it doesn't hurt to ensure that you
> are reading the lines of code in the proper order :)
>
>
> --- Bob Metelsky <bmetelsky_at_CPS92.COM> wrote:
> > Thanks for all the replies...
> >
> > A summary
> >
> > {user|all|dba}_source
> >
> > LOCDB SQL> desc dba_source;
> > Name
> > ---------------------------
> > OWNER
> > NAME
> > TYPE
> > LINE
> > TEXT
> >
> > LOCDB SQL> select distinct type from dba_source ;
> > TYPE
> > ------------
> > FUNCTION
> > PACKAGE
> > PACKAGE BODY
> > PROCEDURE
> > TYPE
> >
> >
> > SELECT TEXT FROM DBA_SOURCE WHERE NAME = 'object_name'
> >
> > bob
> >
> >
> > > Im mucking about in the user_ views...
> > >
> > > Im seeing dba_objects type = 'procedure'; but need to find the sql
> > >
> > > Thanks
> > > bob
> > >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Bob Metelsky
> > INET: bmetelsky_at_cps92.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Tax Center - forms, calculators, tips, more
> http://taxes.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Rachel Carmichael
> INET: wisernet100_at_yahoo.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pat Hildebrand
  INET: pat_at_ssc.upenn.edu

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).