{"id":18586,"library":"n8n-nodes-oracle-database","title":"n8n Nodes Oracle Database","description":"n8n community node for integrating Oracle Database into n8n workflows. Version 0.0.1 is the initial release, allowing querying and managing Oracle databases directly from n8n. This package is specific to the n8n ecosystem, extending n8n with a custom node. It is not a standalone database driver but an n8n node that uses the 'oracledb' package internally. Compared to other database nodes, it focuses on Oracle compatibility. Release cadence is irregular as it is community-maintained.","status":"active","version":"0.0.1","language":"javascript","source_language":"en","source_url":"https://github.com/matheuspeluchi/n8n-nodes-oracle-database","tags":["javascript","n8n-community-node-package","oracle"],"install":[{"cmd":"npm install n8n-nodes-oracle-database","lang":"bash","label":"npm"},{"cmd":"yarn add n8n-nodes-oracle-database","lang":"bash","label":"yarn"},{"cmd":"pnpm add n8n-nodes-oracle-database","lang":"bash","label":"pnpm"}],"dependencies":[{"reason":"Core database driver for Oracle connections; required at runtime.","package":"oracledb","optional":false},{"reason":"Required for n8n node base classes and decorators.","package":"n8n-workflow","optional":false}],"imports":[{"note":"ESM-only package; CommonJS require will fail.","wrong":"const OracleDatabase = require('n8n-nodes-oracle-database')","symbol":"OracleDatabase","correct":"import { OracleDatabase } from 'n8n-nodes-oracle-database'"},{"note":"Only available as named export; no default export.","wrong":"","symbol":"OracleDatabaseV2","correct":"import { OracleDatabaseV2 } from 'n8n-nodes-oracle-database'"},{"note":"TypeScript type; should be imported with 'import type' for tree-shaking.","wrong":"import { IOracleCredentials } from 'n8n-nodes-oracle-database'","symbol":"IOracleCredentials","correct":"import type { IOracleCredentials } from 'n8n-nodes-oracle-database'"}],"quickstart":{"code":"import { OracleDatabase } from 'n8n-nodes-oracle-database';\n\nconst node = new OracleDatabase();\n\nconst credentials = {\n  host: process.env.ORACLE_HOST ?? 'localhost',\n  port: parseInt(process.env.ORACLE_PORT ?? '1521'),\n  user: process.env.ORACLE_USER ?? 'admin',\n  password: process.env.ORACLE_PASSWORD ?? '',\n  database: process.env.ORACLE_DATABASE ?? 'xe',\n};\n\n// Example: execute a query\nconst result = await node.execute({\n  credentials,\n  query: 'SELECT * FROM dual',\n  options: {}\n});\n\nconsole.log(result);","lang":"typescript","description":"Shows how to import the OracleDatabase node and execute a simple query using environment variables for credentials."},"warnings":[{"fix":"Pin to exact version and monitor releases.","message":"Package is in early development (v0.0.1); API may change without notice.","severity":"gotcha","affected_versions":"=0.0.1"},{"fix":"Install Oracle Instant Client and set environment variables (e.g., LD_LIBRARY_PATH or PATH).","message":"Requires Oracle Instant Client or full Oracle Client installed on the system for the 'oracledb' driver to work.","severity":"gotcha","affected_versions":">=0.0.1"},{"fix":"Always use n8n's credential system instead of hardcoding.","message":"Credentials are passed as plain objects; if not stored in n8n's credential vault, they may be exposed in workflow exports.","severity":"gotcha","affected_versions":">=0.0.1"},{"fix":"Reduce parallel executions or implement connection pooling manually.","message":"The node does not support connection pooling; each execution creates a new connection.","severity":"gotcha","affected_versions":"=0.0.1"}],"env_vars":null,"last_verified":"2026-04-25T00:00:00.000Z","next_check":"2026-07-24T00:00:00.000Z","problems":[{"fix":"Set the ORACLE_HOST environment variable to a valid hostname or IP address.","cause":"The Oracle client environment variable ORACLE_HOST is not set or incorrect.","error":"ORA-24454: client host name is not set"},{"fix":"Download and install Oracle Instant Client, and add its location to LD_LIBRARY_PATH (Linux) or PATH (Windows).","cause":"Oracle Instant Client is not installed or not in the library path.","error":"Error: DPI-1047: Cannot locate a 64-bit Oracle Client library"},{"fix":"Use ES module import syntax: import { OracleDatabase } from 'n8n-nodes-oracle-database'","cause":"Using a CommonJS require() on an ESM-only package.","error":"TypeError: OracleDatabase is not a constructor"}],"ecosystem":"npm","meta_description":null,"install_score":null,"install_tag":null,"quickstart_score":null,"quickstart_tag":null}