Skip to Main Content

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!

Search inside a package

487975Jun 4 2007 — edited Jun 5 2007
Hi.

I have a question about searching.
Is there any possibility to search inside a package (stored in the DB) for a string?

The problem is, that we have many packages (not all programmed by us) and we want to write an overview about all user specified errors (rais_application_error) with error-number and -message.

The manually method is, to search with SQL Developer each package for the string. But this would be very inefficient.

Do you know any method to search (maybe via sqlplus?) inside all packages for a string?

Thanks for answering.
Best regards.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 3 2007
Added on Jun 4 2007
7 comments
4,337 views