How to identify a package based on a code snippet 1

[Chopstik]

We currently have a few packages that need to be refactored to work more efficiently as per our DBA's. However, they have only provided snippets of the offending code. While we are now going back through TFS to see if we can identify the offending packages (a manual and laborious process for which we have little time), I am wondering if there is an easier method to identify the packages/procedures to which the offending code may belong. Am hoping someone here may have some ideas. Thanks in advance!

------------------------------------------------------------------------------------------------------------------------
Reason and free inquiry are the only effectual agents against error; they are the natural enemies of error and of error only.

Thomas Jefferson

http://lessthandot.com

 

[Andrzejek]

Try:

[tt]select distinct type, name
from all_source
where owner = '[red]ABC123XYZ[/red]'
and type in('PROCEDURE', 'PACKAGE', 'PACKAGE BODY')
and text like '%[red]your code snippet[/red]%'
order by 1, 2[/tt]

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson