n8n Nodes Oracle Database

0.0.1 verified Sat Apr 25 auth: no javascript

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.

Common errors

error ORA-24454: client host name is not set ↓

cause The Oracle client environment variable ORACLE_HOST is not set or incorrect.

fix

Set the ORACLE_HOST environment variable to a valid hostname or IP address.

error Error: DPI-1047: Cannot locate a 64-bit Oracle Client library ↓

cause Oracle Instant Client is not installed or not in the library path.

fix

Download and install Oracle Instant Client, and add its location to LD_LIBRARY_PATH (Linux) or PATH (Windows).

error TypeError: OracleDatabase is not a constructor ↓

cause Using a CommonJS require() on an ESM-only package.

fix

Use ES module import syntax: import { OracleDatabase } from 'n8n-nodes-oracle-database'

Warnings

gotcha Package is in early development (v0.0.1); API may change without notice. ↓

fix Pin to exact version and monitor releases.

gotcha Requires Oracle Instant Client or full Oracle Client installed on the system for the 'oracledb' driver to work. ↓

fix Install Oracle Instant Client and set environment variables (e.g., LD_LIBRARY_PATH or PATH).

gotcha Credentials are passed as plain objects; if not stored in n8n's credential vault, they may be exposed in workflow exports. ↓

fix Always use n8n's credential system instead of hardcoding.

gotcha The node does not support connection pooling; each execution creates a new connection. ↓

fix Reduce parallel executions or implement connection pooling manually.

Install

npm install n8n-nodes-oracle-database

yarn add n8n-nodes-oracle-database

pnpm add n8n-nodes-oracle-database

Imports

OracleDatabase

wrong

const OracleDatabase = require('n8n-nodes-oracle-database')

correct

import { OracleDatabase } from 'n8n-nodes-oracle-database'

ESM-only package; CommonJS require will fail.

OracleDatabaseV2
```
import { OracleDatabaseV2 } from 'n8n-nodes-oracle-database'
```
Only available as named export; no default export.

IOracleCredentials

wrong

import { IOracleCredentials } from 'n8n-nodes-oracle-database'

correct

import type { IOracleCredentials } from 'n8n-nodes-oracle-database'

TypeScript type; should be imported with 'import type' for tree-shaking.

Quickstart

Shows how to import the OracleDatabase node and execute a simple query using environment variables for credentials.

import { OracleDatabase } from 'n8n-nodes-oracle-database';

const node = new OracleDatabase();

const credentials = {
  host: process.env.ORACLE_HOST ?? 'localhost',
  port: parseInt(process.env.ORACLE_PORT ?? '1521'),
  user: process.env.ORACLE_USER ?? 'admin',
  password: process.env.ORACLE_PASSWORD ?? '',
  database: process.env.ORACLE_DATABASE ?? 'xe',
};

// Example: execute a query
const result = await node.execute({
  credentials,
  query: 'SELECT * FROM dual',
  options: {}
});

console.log(result);