Overview
This node executes SQL queries on an Oracle Database. It supports running custom SQL queries with named parameters, allowing dynamic and flexible data retrieval or manipulation. Common use cases include fetching user data, updating records, or running complex queries with parameters. For example, you can execute a query like 'SELECT * FROM users WHERE id = :id' with a parameter to fetch a specific user.
Use Case Examples
- Fetching user details by ID using a parameterized SELECT query.
- Inserting new records into a table with dynamic values.
- Updating or deleting rows based on specific keys.
Properties
| Name | Meaning |
|---|---|
| Query | The SQL query to execute. Supports named parameters using :paramName syntax. |
| Query Parameters | JSON object containing parameters to bind to the query. Parameter names must match those used in the query. |
| Options | Additional execution options including auto-commit, fetch size, and maximum rows to return. |
Output
JSON
json- The query result rows as an array of objects, or success status with rows affected count.
Dependencies
- Oracle Database client library (oracledb)
- Oracle Database credentials (user, password, connection string)
Troubleshooting
- Invalid JSON in Query Parameters or Procedure Parameters will cause errors; ensure JSON is well-formed.
- Connection issues may arise if Oracle client is not properly installed or configured.
- Errors in SQL syntax or parameter mismatches will throw exceptions; verify query and parameters.
- Ensure the database credentials and connection details are correct to avoid authentication failures.
Links
- OracleDB Node.js Driver Documentation - Official documentation for the Oracle Database Node.js client used by this node.