call_procedure
Execute Oracle stored procedures and package procedures using anonymous PL/SQL blocks. Pass IN parameters as key-value pairs, with automatic commit on writable connections.
Instructions
Call a stored procedure or package procedure via anonymous PL/SQL block. Supports IN parameters only; OUT parameters are not supported. Commits automatically. Only available on writable connections.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| params | No | IN parameters as key-value pairs. OUT parameters not supported. | |
| connection | No | Connection name from list_schemas. Must have readonly=false. | |
| procedure_name | Yes | Procedure or package name, e.g. 'MY_PROC' or 'PKG.PROC'. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |