list_procedures
Retrieve Oracle stored procedures, functions, packages, and types by schema, name pattern, or object type to inspect available database routines and objects.
Instructions
List stored procedures, functions, packages and types. Optional schema, LIKE name pattern and object type filter.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| type | No | Object type, e.g. 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TABLE', 'VIEW'. | |
| schema | No | Schema (owner) name. Omit to search all schemas. | |
| namePattern | No | LIKE pattern for the object name. Defaults to '%'. |