Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
Description
Procedures and functions that are not part of a package have rows in:
- information_schema.ROUTINES
- informatino_schema.PARAMETERS (if they have parameters)
Procedures and functions that are part of a package are missing. Please include them, and add a column for the package name (Oracle calls it OBJECT_NAME).
NOTE: I'm aware that we have packages and package bodies in the information_schema.ROUTINES table, and the procedures definitions are there in a text form. This is useful, but parsing SQL would be very inconvenient.