Database Utilities (MOSC)

MOSC Banner

Extract code for a specific procedure from a package

edited Mar 11, 2013 7:52AM in Database Utilities (MOSC) 3 commentsAnswered
Hi there,
I need to review a few hundred procedures that are stored within number packages on our database in order to resolve an issue we've just discovered. I know the names of the procedures I need to get at, but I'd like to find a way to pull out the procedure declaration from the package spec. I'm not trying to extract ALL procedures in the package, just specific ones. I know that dba_procedures will give me a list of the procedures in a package, but I need to look at the parameter list for each of these procedures. I was going

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center