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 procedure that performs batch data processing 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 where keys are parameter names and values are parameter values. |
| Options | Additional execution options including auto-commit (whether to commit transactions automatically), fetch size (number of rows to fetch at a time), and max rows (maximum number of rows to return). |
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 that the JSON format for procedure parameters is valid; invalid JSON will cause errors.
- If connection fails, verify credentials and connection string parameters (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 under 'error'.
Links
- OracleDB Node.js Driver Documentation - Official documentation for the Oracle Database Node.js driver used by this node.