n8n Oracle Database Parameterization Node

1.1.4 verified Sat Apr 25 auth: no javascript

An n8n community node for connecting to Oracle databases with parameterized query support. Current version 1.1.4, released as a fork of n8n-nodes-oracle-database adding bind variable functionality. Updated irregularly. Key differentiator: enables safe SQL injection prevention via parameterized queries compared to the parent node. Requires n8n and oracledb driver. Limited to n8n workflows.

Common errors

error ERROR: Cannot find module 'n8n-nodes-oracle-database-parameterization' ↓

cause Package not installed or n8n not configured to load community nodes.

fix

Install with: npm install n8n-nodes-oracle-database-parameterization in the n8n installation directory, then restart n8n.

error Error: ORA-01017: invalid username/password; logon denied ↓

cause Incorrect Oracle database credentials.

fix

Verify username, password, host, port, and service name in the node's credential settings.

error TypeError: Cannot read properties of undefined (reading 'execute') ↓

cause Query parameter missing or incorrect node configuration.

fix

Ensure the 'Query' field is not empty and contains a valid SQL statement. Also verify credentials are properly set.

Warnings

gotcha Parameterization only works when using :name bind variables. Avoid concatenating user input into SQL strings. ↓

fix Always use parameterized syntax like SELECT * FROM table WHERE id = :paramName.

gotcha The node is a fork of n8n-nodes-oracle-database. Ensure you have uninstalled the original to avoid conflicts. ↓

fix Run: npm uninstall n8n-nodes-oracle-database && npm install n8n-nodes-oracle-database-parameterization

breaking Node name changed from 'Oracle Database' to 'Oracle Database Parameterization'. Workflows referencing old node name will break. ↓

fix Update workflow node names in n8n editor to 'Oracle Database Parameterization'.

Install

npm install n8n-nodes-oracle-database-parameterization

yarn add n8n-nodes-oracle-database-parameterization

pnpm add n8n-nodes-oracle-database-parameterization

Imports

OracleDatabaseParameterization
```
import { OracleDatabaseParameterization } from 'n8n-nodes-oracle-database-parameterization'
```
Default export is the main node class. Use named import for TypeScript.

OracleDatabaseParameterization (in n8n credentials)

wrong

import OracleDatabaseParameterization from 'n8n-nodes-oracle-database-parameterization';

correct

const { OracleDatabaseParameterization } = require('n8n-nodes-oracle-database-parameterization');

n8n nodes are typically loaded via CommonJS require in n8n's custom node loader. ESM import may fail.

IOracleDatabaseParameterizationCredentials
```
import type { IOracleDatabaseParameterizationCredentials } from 'n8n-nodes-oracle-database-parameterization'
```
TypeScript type for credentials object. Available if types are included in package.

Quickstart

Demonstrates importing the node and using parameterized queries to prevent SQL injection in Oracle DB workflows.

import { OracleDatabaseParameterization } from 'n8n-nodes-oracle-database-parameterization';

// Register node in n8n's node list (typical in n8n custom node setup)
const myNode = new OracleDatabaseParameterization();

// Example workflow: parameterized query execution
// In n8n editor, configure the node with:
// Query: "SELECT * FROM users WHERE id = :id AND status = :status"
// Parameters (JSON): {"id": 123, "status": "active"}
// Credentials: Oracle DB connection (host, port, service name, user, password)