Skip to main content

Oracle Node

What it does​

Executes Oracle SQL operations using Oracle credentials and returns query results or execution metadata.

Inputs/config​

  • Oracle credential reference.
  • SQL text and bind parameters.
  • Optional fetch size/timeout settings.

Outputs/branches​

  • Uses matched_output.
  • success for completed operations.
  • error for SQL parse, auth, or connectivity failures.

Example usage snippet​

{
  "id": "n_oracle",
  "type": "oracle_node",
  "config": {
    "query": "select * from CUSTOMERS where CUSTOMER_ID = :id",
    "params": { "id": "{{input.customerId}}" }
  }
}

Common pitfalls​

  • Incorrect bind variable syntax (:name) for Oracle.
  • Case/identifier mismatches with quoted table names.
  • Large result sets without pagination controls.