Overview
This node connects to an Oracle Database and performs various database operations such as inserting rows into a table. It is useful for automating data insertion tasks in Oracle databases, for example, adding new user records or logging events. The node supports specifying the target table, columns to insert, and options like auto-commit for transaction control.
Use Case Examples
- Insert new user data into a 'users' table by specifying columns like 'id', 'name', and 'email'.
- Automate batch insertion of records into a sales table with control over transaction commit behavior.
Properties
| Name | Meaning |
|---|---|
| Table | The name of the table where rows will be inserted. |
| Columns | Comma-separated list of columns to insert values into. |
| Options | Additional settings for the insert operation, including auto-commit, fetch size, and max rows. |
Output
JSON
jsonsuccess- Indicates if the insert operation was successful.rowsAffected- Number of rows affected by the insert operation.
Dependencies
- Oracle Database client library (oracledb)
Troubleshooting
- Ensure Oracle client libraries are installed and properly configured, as the node attempts to initialize the Oracle client.
- Verify that the table name and columns specified exist in the database and match the data provided.
- Check that the credentials for the Oracle database connection are correct and have sufficient permissions for insert operations.
- If JSON parsing errors occur in parameters, ensure the input JSON is valid.
- Common error messages include connection failures, SQL syntax errors, and permission denied errors. Resolving these typically involves checking connection details, SQL syntax, and user privileges.
Links
- OracleDB Node.js Driver Documentation - Official documentation for the Oracle Database Node.js driver used by this node.