Overview
This node connects to an Oracle Database and performs delete operations on specified tables. It deletes rows based on a matching column value, which is configurable. This node is useful for automating data cleanup or removal tasks in Oracle databases, such as deleting user records, removing outdated entries, or managing data lifecycle in applications.
Use Case Examples
- Delete user records from a 'users' table where the 'id' matches a given value.
- Remove entries from a 'logs' table based on a timestamp or log ID.
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 query results, and maximum rows to return. |
Output
JSON
jsonsuccess- Indicates if the delete operation was successful (true/false).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.
- Check that the value used for matching rows to delete is present and correctly formatted.
- Common error: 'Invalid JSON in Query Parameters' or 'Invalid JSON in Procedure Parameters' - occurs if JSON input is malformed; ensure JSON syntax is correct.
- Connection errors may occur if the Oracle client is not properly installed or configured; verify Oracle client installation and environment variables.
Links
- OracleDB Node.js Driver Documentation - Official documentation for the Oracle Database Node.js client used by this node.