Overview
This node executes stored procedures on an Oracle Database. It allows users to specify the procedure name and pass parameters in JSON format. The node supports options such as auto-commit, fetch size, and maximum rows to control transaction behavior and data retrieval. It is useful for automating database operations that require calling predefined procedures, such as data processing, batch updates, or complex business logic encapsulated in the database.
Use Case Examples
- Calling a stored procedure to update user records based on input parameters.
- Executing a batch job stored procedure that processes data and returns output binds.
Properties
| Name | Meaning |
|---|---|
| Procedure Name | The name of the stored procedure to execute. |
| Procedure Parameters | Parameters to pass to the stored procedure, provided as a JSON object. |
| Options | Additional execution options including auto-commit, fetch size, and max rows. |
Output
JSON
success- Indicates if the stored procedure execution was successful.outBinds- Output bind variables returned from the stored procedure, if any.
Dependencies
- Oracle Database client library (oracledb)
Troubleshooting
- Ensure the Oracle client is properly installed and configured, as the node attempts to initialize it and may skip if not found.
- Verify that the stored procedure name and parameters are correct and match the database definition.
- Check JSON formatting for procedure parameters; invalid JSON will cause errors.
- If connection fails, verify credentials and connection string details (host, port, service name).
- Errors during execution will be thrown unless 'Continue On Fail' is enabled, in which case errors are returned in the output JSON.