Overview
This node performs delete operations on an Oracle Database table. It deletes rows from a specified table based on a matching column value, which is configurable. This node is useful in scenarios where you need to remove specific records from a database, such as deleting user data by user ID or removing outdated entries from a log table.
Use Case Examples
- Deleting a user record from the 'users' table where the 'id' matches a given value.
- Removing entries from a 'logs' table where the 'timestamp' is older than a certain date.
Properties
| Name | Meaning |
|---|---|
| Table | The name of the table from which rows will be deleted. |
| Delete Key | The column used to match rows for deletion. |
| Options | Additional options for the delete operation, including auto-commit of transactions, fetch size for rows, and maximum number of rows to return. |
Output
JSON
jsonsuccess- Indicates if the delete operation was successful.rowsAffected- Number of rows that were deleted.
Dependencies
- Oracle Database client library (oracledb)
Troubleshooting
- Ensure the Oracle Database credentials are correct and have sufficient permissions to delete rows.
- Verify that the table name and delete key column exist in the database schema.
- If the node throws an error about invalid JSON, check that the input parameters are correctly formatted JSON.
- Connection errors may occur if the Oracle client is not properly installed or configured.
Links
- OracleDB Node.js Driver Documentation - Official documentation for the Oracle Database Node.js client used by this node.