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.
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"}) |