Source code for a specific stored procedure or function

Question

I can use all_arguments and all_procedures to list the procedures and functions inside any given package and using DBMS_METADATA. I can extract DDL for this package. Is there an easy way (besides a lot of instring and substring calls) to get the source code of a procedure or function separately for each individual code block in a package.

Something like that:

Owner | Package Name | Object Name | Overload | Arguments | Source

Obviously, using substring and instring will present problems with overloaded functions.

All_arguments has a subprogram_id field, which, in accordance with very sparse documentation, looks like it uniquely refers to the procedure with which it is associated in the package, but it seems to be not using anything.

Greetings in advance

Answer 1

IIRC, PLSQL . , "instring" "substring" , , ( ). , . , , , , , , , , .

PLSQL . DMS Software Reengineering Toolkit PLSQL.

, PLSQL; (AST) . , AST . , ; , , , . AST, DMS ( ) .