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 into tables, updating rows, deleting rows, and executing stored procedures. It is useful for automating database interactions within workflows, such as inserting new records, updating existing data, or running complex queries and procedures.

Use Case Examples

  1. Insert new user records into a users table by specifying the table name and columns.
  2. Execute a custom SQL query to retrieve data based on parameters.
  3. Update specific rows in a table by matching a key column.
  4. Delete rows from a table based on a key column value.

Properties

Name Meaning
Table The name of the database table to operate on (required for insert, update, delete operations).
Columns Comma-separated list of columns to insert values into (used only for insert 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 and continueOnFail is enabled.

Dependencies

  • Oracle Database client library (oracledb)

Troubleshooting

  • Ensure Oracle client libraries are installed and properly configured to avoid initialization errors.
  • Verify database connection credentials and connection string parameters are correct.
  • Check that the table name and column names exist in the database and are spelled correctly.
  • For JSON input parameters (queryParams, procedureParams), ensure valid JSON format to avoid parsing errors.
  • If an error occurs during execution, the node throws an error unless 'continueOnFail' is enabled, in which case it outputs the error message in the JSON output.

Links

Discussion