BGS-Oracledb-connector icon

BGS-Oracledb-connector

Execute queries on Oracle Database
Join our community

Actions5

Overview

This node connects to an Oracle Database and performs various database operations such as executing SQL queries, inserting rows, updating rows, deleting rows, and executing stored procedures. It is useful for automating database interactions within workflows, such as updating user records, inserting new data entries, or running complex stored procedures.

Use Case Examples

  1. Updating user information in a database table based on a unique key.
  2. Inserting new records into a specified table with defined columns.
  3. Executing a stored procedure to perform batch operations or complex logic on the database.

Properties

Name Meaning
Table The name of the database table to operate on, required for insert, update, and delete operations.
Update Key The column name used to match rows for updating in the update operation.
Options Additional options for the database operation such as auto-commit, fetch size, and maximum rows to return.

Output

JSON

  • json
    • success - Indicates if the operation was successful (true/false).
    • rowsAffected - Number of rows affected by the operation (insert, update, delete).
    • outBinds - Output bindings returned from executing a stored procedure, if any.
    • error - Error message if the operation failed.

Dependencies

  • Oracle Database client library (oracledb)

Troubleshooting

  • Common issues include invalid SQL syntax, incorrect table or column names, and connection failures due to wrong credentials or network issues.
  • Errors parsing JSON input for query or procedure parameters can occur if the JSON is malformed.
  • If the Oracle client initialization fails, the node logs a message but attempts to continue, which might cause connection issues if the client is required.
  • Ensure the update key column exists in the table and matches the data provided for update operations.

Links

Discussion