How to DESC one procedure from a package
Posted on 2008-06-13
We have a situation where we are connecting data silos with common APIs via packages. In one situation, the packages we want to introduce can be automatically generated based on the footprint of those packages in another silo. However, that silo includes a lot of cruft in one of the core packages. Until we can refactor and partition the package, I'd like to create a simple Perl script (or something similar) that takes a list of procedures in the package, does something like a DESC to get the footprint, and generates the package code. Is there a PL/SQL query using dictionary tables (or something akin) that will allow me to DESC the footprint of a single procedure from within a package?