dba_source has the source code.
dba_objects will the the type of the object.
G!
--- Steff Gonos <steff_gonos_at_yahoo.com> wrote: > I am
trying to find out where and how procedures are
> stored in the database. I am actually looking for
> the
> procedure name and the source code.
>
> Where do I start ?
>
> Thanks.
>
>
> =====
>
> A day without sunshine is like, well, night.
>
>
> Steff Gonos
> steff_gonos_at_yahoo.com
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Mail – Free email you can access from
> anywhere!
> http://mail.yahoo.com/
> --
> Author: Steff Gonos
> INET: steff_gonos_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> 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! Mail – Free email you can access from anywhere!
Received on Mon Aug 21 2000 - 15:40:51 CDT