Oracle

Oracle Database: run SQL queries, inserts, updates, and stored procedures

Oracle documentationAPI checked August 16, 2026

Signs in with: Connection details
Runs on: Cloud or On-Prem Worker
Operations: 13
Ready-made triggers: 0

Connect Oracle

In Neblex open Connect › Connections and click New Connection.
Search for Oracle and give the connection a clear name.
Fill in the fields. Secret values are encrypted and never shown again.
Click Test, then Create Connection.

If the system is only reachable inside your network, choose an On-Prem Worker under Test from and run the flow on that Worker. See On-Prem Workers.

Field	What to enter
Connection setupRequired
HostRequired
PortOptional	Example: `1521`
Service nameRequired
UserRequired
PasswordRequiredSecret
Encrypt with TLSOptional	Turning this off sends traffic and credentials without transport encryption. Use plaintext only for a customer-controlled endpoint that explicitly requires it.
Connection stringRequiredSecret	Paste a tcps:// connection string for certificate-verified TLS, or oracle:// only when the customer endpoint explicitly requires plaintext. URL query options are not supported.

Use it in a flow

Open a flow, open the node library and search for Oracle.
Drag it onto the canvas and choose an Operation and your connection.
Map the operation's fields from earlier steps, or click Map with Matt.
Use Test this step to see what it returns, then save.

To start a flow from Oracle without a ready-made trigger: a Poll for changes trigger on Oracle with your own query passes on new or changed records.

Operations

13 operations in 1 groups. Each one is a step you can add to a flow.

SQL13

Delete rows (mapped)`delete`		Delete the row matching the key columns of each record.
Execute command`command`		Execute the Oracle DML, DDL, CALL, or PL/SQL entered in the statement editor.
Execute query`query`		Execute the Oracle SQL entered in the statement editor with bound :name parameters.
Get server time`serverTime`		Return the current Oracle Database timestamp.
Get server version`serverVersion`		Return the Oracle Database server banner.
Get table statistics`tableStatistics`		Return catalog row estimates and analysis time for every visible table matching the supplied name.
Insert rows (mapped)`insert`		Insert one row per record into a table you pick, mapping each column from the record.
List table columns`listColumns`		List the columns and data types for every visible table matching the supplied name.
List tables`listTables`		List every table visible to the connected Oracle user with its owner.
Select rows (mapped)`select`		Read rows from a table you pick: choose the columns to return, filter by the column values you map, order and limit.
Test Oracle`ping`		Run a minimal query and return ok=1.
Update rows (mapped)`update`		Update the row matching the key columns of each record, setting the other mapped columns.
Upsert rows (mapped)`upsert`		Insert one row per record, or update the existing row when the key columns already match.