Remember the bad old days when you knew which procedure/function you wanted to look at but couldn't remember the package name? Or you weren't quite sure of the correct procedure/function name but you needed to find it PDQ?

OK, well if you're lucky enough to be on 9i theres a new 'ALL_' view, ALL_PROCEDURES, that will go a long way to healing the pain. Don't be fooled by the name though; it contains functions as well.

So a noddy select statement like

SELECT OBJECT_NAME
FROM ALL_PROCEDURES
WHERE PROCEDURE_NAME = '<procedure or function name>'
will tell you all you ever wanted to know about the package to go look for.

Of course if you're logged in as, say, APPS, and you're only interested in apps packages then USER_PROCEDURES will give you just those.

Don't delay try it today <img src="/ubbthreads/images/graemlins/smile.gif" alt="" />

This has been........ another............. Janet & John Public Service Announcement

L+K
J+J