{"id":18584,"library":"n8n-nodes-oracle-database-parameterization","title":"n8n Oracle Database Parameterization Node","description":"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.","status":"active","version":"1.1.4","language":"javascript","source_language":"en","source_url":"https://github.com/jgriffin1/n8n-nodes-oracle-database-parameterization","tags":["javascript","n8n-community-node-package","oracle"],"install":[{"cmd":"npm install n8n-nodes-oracle-database-parameterization","lang":"bash","label":"npm"},{"cmd":"yarn add n8n-nodes-oracle-database-parameterization","lang":"bash","label":"yarn"},{"cmd":"pnpm add n8n-nodes-oracle-database-parameterization","lang":"bash","label":"pnpm"}],"dependencies":[{"reason":"Core n8n dependency for node registration and execution","package":"n8n-workflow","optional":false},{"reason":"Oracle database driver for Node.js","package":"oracledb","optional":false}],"imports":[{"note":"Default export is the main node class. Use named import for TypeScript.","wrong":"","symbol":"OracleDatabaseParameterization","correct":"import { OracleDatabaseParameterization } from 'n8n-nodes-oracle-database-parameterization'"},{"note":"n8n nodes are typically loaded via CommonJS require in n8n's custom node loader. ESM import may fail.","wrong":"import OracleDatabaseParameterization from 'n8n-nodes-oracle-database-parameterization';","symbol":"OracleDatabaseParameterization (in n8n credentials)","correct":"const { OracleDatabaseParameterization } = require('n8n-nodes-oracle-database-parameterization');"},{"note":"TypeScript type for credentials object. Available if types are included in package.","wrong":"","symbol":"IOracleDatabaseParameterizationCredentials","correct":"import type { IOracleDatabaseParameterizationCredentials } from 'n8n-nodes-oracle-database-parameterization'"}],"quickstart":{"code":"import { OracleDatabaseParameterization } from 'n8n-nodes-oracle-database-parameterization';\n\n// Register node in n8n's node list (typical in n8n custom node setup)\nconst myNode = new OracleDatabaseParameterization();\n\n// Example workflow: parameterized query execution\n// In n8n editor, configure the node with:\n// Query: \"SELECT * FROM users WHERE id = :id AND status = :status\"\n// Parameters (JSON): {\"id\": 123, \"status\": \"active\"}\n// Credentials: Oracle DB connection (host, port, service name, user, password)","lang":"typescript","description":"Demonstrates importing the node and using parameterized queries to prevent SQL injection in Oracle DB workflows."},"warnings":[{"fix":"Always use parameterized syntax like SELECT * FROM table WHERE id = :paramName.","message":"Parameterization only works when using :name bind variables. Avoid concatenating user input into SQL strings.","severity":"gotcha","affected_versions":"*"},{"fix":"Run: npm uninstall n8n-nodes-oracle-database && npm install n8n-nodes-oracle-database-parameterization","message":"The node is a fork of n8n-nodes-oracle-database. Ensure you have uninstalled the original to avoid conflicts.","severity":"gotcha","affected_versions":"*"},{"fix":"Update workflow node names in n8n editor to 'Oracle Database Parameterization'.","message":"Node name changed from 'Oracle Database' to 'Oracle Database Parameterization'. Workflows referencing old node name will break.","severity":"breaking","affected_versions":"1.0.0+"}],"env_vars":null,"last_verified":"2026-04-25T00:00:00.000Z","next_check":"2026-07-24T00:00:00.000Z","problems":[{"fix":"Install with: npm install n8n-nodes-oracle-database-parameterization in the n8n installation directory, then restart n8n.","cause":"Package not installed or n8n not configured to load community nodes.","error":"ERROR: Cannot find module 'n8n-nodes-oracle-database-parameterization'"},{"fix":"Verify username, password, host, port, and service name in the node's credential settings.","cause":"Incorrect Oracle database credentials.","error":"Error: ORA-01017: invalid username/password; logon denied"},{"fix":"Ensure the 'Query' field is not empty and contains a valid SQL statement. Also verify credentials are properly set.","cause":"Query parameter missing or incorrect node configuration.","error":"TypeError: Cannot read properties of undefined (reading 'execute')"}],"ecosystem":"npm","meta_description":null,"install_score":null,"install_tag":null,"quickstart_score":null,"quickstart_tag":null}