execute_procedure
Execute Oracle stored procedures with input and output parameters. Specify procedure name and provide parameter values to get results.
Instructions
Execute a stored procedure with input and output parameters.
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>",
"procedure": "<procedure>"
},
"name": "execute_procedure"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| params | No | Input parameters as key-value pairs | |
| procedure | Yes | Name of the stored procedure (can include schema: SCHEMA.PROCEDURE_NAME) | |
| connection | Yes | Name of the database connection to use | |
| out_params | No | Output parameters with their types (e.g., {"result": "string", "count": "int"}) |