Oracle AI Database Node
Use the n8n Oracle AI Database node to execute SQL and select, insert, update, or delete data in Oracle AI Database workflows.
Contents
Requirements
Use Oracle AI Database 19c or later. The node uses the node-oracledb driver internally.
For advanced features such as Transparent Application Continuity and Sharding, use Oracle Client Libraries 19c or later.
Configure the Credential
Create or select an Oracle AI Database credential in the node. Provide the connection information required by your Oracle environment, including the user, password, host, port, and service or connection string.
Review Operations
The node supports these operations:
- Delete: Truncate a table, delete matching rows, or drop a table.
- Execute SQL: Execute SQL or PL/SQL statements.
- Insert: Insert rows into a table with manual or automatic column mapping.
- Insert or Update: Insert new rows or update rows using the selected mapping mode.
- Select: Select rows with optional conditions, sorting, and a result limit.
- Update: Update rows in a table.
Use the Options section to configure autocommit, statement batching, output columns, fetch array size, number of rows to prefetch, and numeric output handling where supported.
Use Bind Parameters
Use bind variables in Execute SQL statements instead of concatenating values into SQL. n8n sanitizes statement parameters passed through the bind-variable fields.
For example, use a named bind variable:
SELECT * FROM fruits WHERE color = :colorThen provide the value for color in the Bind Variable Placeholder Values option. Use an n8n expression when the value comes from an input item.
n8n expressions can provide values for Oracle data types such as JSON, VECTOR, BLOB, RAW, BOOLEAN, and NUMBER. For example, a VECTOR value can be provided as an array: