finding a function named...

[roscoe]

Hi,
Is there a feature in PL/SQL Developer that will let me search through all my api's for a function by a string contained in the function name? For instance I would like to see all the functions in any of the api's that contain the string 'get' rather than try to guess in what package the function I'm looking for resides,
Thanks in advance for any help

 

[Worker]

I believe you're looking for Tools->Find Database Objects...

 

[roscoe]

Hi,
Thanks for the reply but I'm having a little trouble using the find function.
Say I wanted to find a function within an api where the function name contained the string 'xyz' - how would I set up the tool to do that?
Thanks much in advance for any help,
Roscoe

 

[Worker]

Generally, just typing xyz in the "text to find" field and clicking "search" will do it.

If the function you're looking for is owned by the database user you're currently logged in as, then having "" under "Owner" would do it. If not, then you'll have to select the correct owner first.

If you know you're looking for just functions, then selecting "function" under "Object Types" would be important and deselecting the rest would speed up the search.

I don't know how you define "api", but this tool will only search through the database and look at objects that the currently logged in user can access. If your "api" is accessed via a database link or is otherwise outside of the current database, this tool won't be able to help.

 

[roscoe]

Hi Worker,
Thanks for the quick response. It's my bad with the terminology, should have used "package" or "package body" instead of "api"
Thanks again, Roscoe