Extract code for a specific procedure from a package
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
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
0