Oracle Complex Query¶
Executes complex Oracle SQL statements, including multi-table JOINs and advanced clauses. It sends the provided SQL and a declared query type to the Oracle service using stored credentials, then returns a formatted textual summary alongside structured result data.
Usage¶
Use this node when you need to run sophisticated Oracle SQL beyond simple selects, such as multi-table joins, window functions, or aggregations. Place it in workflows that read from Oracle databases and consume the results as text for viewing and as structured data for downstream processing or export.
Inputs¶
| Field | Required | Type | Description | Example |
|---|---|---|---|---|
| credentials_path | True | STRING | Path or reference to stored Oracle credentials that follow the Oracle credential template. | /secrets/connections/oracle.json |
| timeout | False | INT | Maximum time in seconds to wait for the Oracle operation to complete before failing. | 120 |
| sql_text | True | STRING | The SQL query to execute. Supports complex SELECTs with JOINs and advanced SQL features. | SELECT e.employee_id, e.first_name, e.last_name, d.department_name FROM employees e JOIN departments d ON e.department_id = d.department_id WHERE e.salary > 75000 |
| query_type | True | STRING | Declares the type of the query being executed (e.g., SELECT). Used to route the request appropriately. | SELECT |
Outputs¶
| Field | Type | Description | Example |
|---|---|---|---|
| text | STRING | Human-readable summary or table-like rendering of the query results. | Oracle Complex Query (SELECT): 25 rows returned |
| json | JSON | Structured data for the query result, suitable for programmatic consumption. | {"rows": [{"EMPLOYEE_ID": 101, "FIRST_NAME": "Neena", "LAST_NAME": "Kochhar", "DEPARTMENT_NAME": "Executive"}], "row_count": 25} |
Important Notes¶
- Ensure that the credentials referenced by credentials_path are valid and configured for the Oracle service template.
- query_type should align with the SQL you provide (e.g., SELECT). Mismatched types may lead to errors.
- Parameter placeholders (e.g., :min_salary) are not bound by separate inputs in this node. Provide fully resolved SQL or ensure your backend supports inline parameters as used.
- Large result sets may increase execution time. Use WHERE, GROUP BY, and FETCH FIRST (row limiting) where appropriate.
- The node returns a readable text summary and structured JSON. Export formats beyond these are not generated by this node.
Troubleshooting¶
- SQL error returned: Verify sql_text syntax and that all referenced tables/columns exist and are accessible to the provided user.
- Timeout exceeded: Increase the timeout input or optimize the query with filters and indexes.
- Permission denied: Confirm the Oracle user in credentials has sufficient privileges to read the referenced objects.
- Empty results: Check WHERE conditions and join predicates; test the query directly in your database client to validate expectations.
- Invalid query_type: Use a supported type string (e.g., SELECT) that matches the SQL operation you are running.