list_procedures
Retrieve a list of stored procedures, functions, and packages in an Oracle database schema, with optional filtering by name pattern and object type.
Instructions
List stored procedures, functions, and packages in a schema.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"connection": "<connection>"
},
"name": "list_procedures"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| type | No | Filter by object type | |
| filter | No | LIKE pattern to filter object names | |
| schema | No | Schema name (defaults to current user's schema) | |
| connection | Yes | Name of the database connection to use |