mossmis
asked on
Search Oracle DB Store Procedures/Functions for Specific Text
I need to find a stored procedure or function that contains a certain text phrase in the code in Oracle. Is there a way to search these objects for text? I am using Oracle SQL Developer. Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
if you can read dba_source then there is nothing higher.
if you can't read it then you'll need elevated privileges from your DBA
it's also possible the string doesn't appear within your code exactly as you're looking for it.
'this is a test string'
might be constructed on the fly
'this is a' || ' a test' || ' string'
or it might read from a table
or the code might be wrapped.
if you can't read it then you'll need elevated privileges from your DBA
it's also possible the string doesn't appear within your code exactly as you're looking for it.
'this is a test string'
might be constructed on the fly
'this is a' || ' a test' || ' string'
or it might read from a table
or the code might be wrapped.
ASKER
Ok, I was looking for a server name or IP address hard coded in the code. It might not be there. I was going on a hunch I ran a test with something I knew would be there, and it worked. I guess I have to start digging in the Linux OS to find it. Thanks for your help.
ASKER