Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
Description
Procedures and functions that are not part of a package are described in:
- information_schema.ROUTINES
- informatino_schema.PARAMETERS (if they have parameters)
Procedures and functions that are part of a package are not in those tables. Please include them, and add a column for the package name (Oracle calls it OBJECT_NAME).
NOTE: I'm aware that we can see CREATE PACKAGE and CREATE PACKAGE BODY statements in the information_schema.ROUTINES table. This is useful for taking dumps, but to get specific information we shouldn't have to parse SQL.