SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Fetching source code of a procedure from a huge package in oracle

801360Aug 19 2012 — edited Aug 20 2012

I have a package which as 40-50 methods in them, i would like to retrieve the source of one of the procedure from package. is there a table from which i can fetch this detail in oracle database.

I know there is a table all_source, that has the source code of the entire package, but i want to get only the source code of a specific procedure.

thanks in advance.

This post has been answered by Etbin on Aug 19 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 17 2012

Added on Aug 19 2012

9 comments

5,095 views