Oracle SQL Query

Description

The Oracle SQL Query module allows executing SQL queries on Oracle databases. It uses the oracledb library and supports dynamic variables in the query. Results are returned in object format (OUT_FORMAT_OBJECT) for easier processing in subsequent workflow nodes. It is ideal for integrations with enterprise systems based on Oracle Database.

Configuration

Parameter	Type	Required	Description
credentials_id	credentials	Yes	Oracle connection credentials
query	code	Yes	SQL query to execute (supports `{{variable}}` variables)

Credentials

The credential must contain the fields:

host: Oracle server address
user: Database user
password: User password
database: Oracle service name/SID
port: Connection port (default: 1521)

The connection string is built as: host:port/database

Output

{
  "nextModule": "siguiente_modulo",
  "data": [
    { "ID": 1, "NOMBRE": "Ejemplo", "ESTADO": "ACTIVO" }
  ]
}

Usage Example

Basic case

{
  "credentials_id": "cred_oracle_01",
  "query": "SELECT * FROM clientes WHERE ROWNUM <= 100"
}

Automatic single-quote escaping

When a {{field}} variable contains a text value with single quotes, the engine automatically escapes them by doubling the character (' → '') before executing the query. No additional function is needed.

-- Input: product = "L'Oreal Shampoo"
INSERT INTO products (name) VALUES ('{{product}}')
-- Executed: INSERT INTO products (name) VALUES ('L''Oreal Shampoo')

Numeric values are not escaped — use them without quotes in the template: {{price}}.

Notes

Supports dynamic variables {{variable}} in the SQL query
Text values with single quotes are automatically escaped (' → '')
Results are returned in object format (oracledb.OUT_FORMAT_OBJECT), meaning each row is a key-value object
Column names in Oracle are usually in UPPERCASE
The connection is automatically closed in the finally block
In case of SQL error, the executed query is included in the error message

sqlQuery (MySQL queries)
sqlQueryMSSQL (SQL Server queries)
sqlQueryPostgres (PostgreSQL queries)
sqlQueryPostgresSSL (PostgreSQL queries with SSL)