Registry / database / n8n-nodes-oracle-database-parameterization

n8n-nodes-oracle-database-parameterization

JSON →
library1.1.4jsnpmunverified

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.

npm install n8n-nodes-oracle-database-parameterization
INSTALL
IMPORT
SIG · N8N-NODES-ORACLE-D
N
n8n-nodes-oracle-database-parameterization
databasejavascriptv1.1.4
Install
Import
Disk
Pass rate
0/ 6
Env Coverage0 / 6
glibc
1822
musl
1822
Install & Compatibility
Where this runs
tested against v? · npm install
Install × environment matrix
Each cell = how many times install + import succeeded across repeated harness runs. Partial = flaky.
glibc = Debian/Ubuntu slim · musl = Alpine Linux
musl
node 18226 runs
build_error
glibc
node 18226 runs
build_error
Code
Verified usage

Verified import paths — ran on the pinned version, not inferred.

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)
const { OracleDatabaseParameterization } = require('n8n-nodes-oracle-database-parameterization');
import OracleDatabaseParameterization from '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.

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)
Debug
Known issues
gotchaParameterization 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.
affects: *
gotchaThe 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
affects: *
breakingNode 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'.
affects: 1.0.0+
Errors
Common errors & fixes
ERROR: Cannot find module 'n8n-nodes-oracle-database-parameterization'
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: ORA-01017: invalid username/password; logon denied
Incorrect Oracle database credentials.
fix
Verify username, password, host, port, and service name in the node's credential settings.
TypeError: Cannot read properties of undefined (reading 'execute')
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.
Upgrade
Version history
1.1.4latest on npm
Audit
Dependencies
n8n-workflowrequiredCore n8n dependency for node registration and execution
oracledbrequiredOracle database driver for Node.js
Agent activity
4 hits · last 30 days
node
4
Resources
n8n-nodes-oracle-database-parameterization — npm install n8n-nodes-oracle-database-parameterization · libregistry