Overview

Oracle Database is a multi-model relational database management system widely used for enterprise workloads. The Ballerina ballerinax/oracledb connector (v1.17.0) provides programmatic access to Oracle Database through JDBC, enabling you to execute queries, perform CRUD operations, call stored procedures, and work with Oracle-specific data types such as VARRAYs, nested tables, OBJECT types, and interval types within your Ballerina integration flows. It also supports real-time Change Data Capture (CDC) through a LogMiner-based listener.

Key features

• Execute parameterized SQL queries with streaming result sets via query and single-row retrieval via queryRow
• Perform DML operations (INSERT, UPDATE, DELETE) with execute and batch operations with batchExecute
• Call stored procedures and functions with IN, OUT, and INOUT parameters using call
• Native support for Oracle-specific types: VARRAY, nested tables, OBJECT types, and INTERVAL types
• Change Data Capture (CDC) listener powered by Debezium LogMiner for real-time onRead, onCreate, onUpdate, onDelete, and onError events
• SSL/TLS-secured connections with configurable keystore and truststore
• Connection pooling with configurable pool size, idle connections, and timeouts
• XA datasource support for distributed transactions
• GraalVM native image compatible for ahead-of-time compilation

Actions

Actions are operations you invoke on an Oracle database from your integration, including querying records, inserting data, calling stored procedures, and more. The Oracle DB connector exposes actions through a single client:

Client	Actions
Client	SQL queries, DML execution, batch operations, stored procedure calls

See the Action Reference for the full list of operations, parameters, and sample code for each client.

Triggers

Triggers allow your integration to react to data changes happening in an Oracle database in real time. The connector uses Debezium-based Change Data Capture (CDC) to stream row-level change events to an oracledb:CdcListener, which invokes your service callbacks automatically.

Supported trigger events:

Event	Callback	Description
Record read (snapshot)	onRead	Fired during the initial snapshot when existing rows are read from the database.
Record created	onCreate	Fired when a new row is inserted into a monitored table.
Record updated	onUpdate	Fired when an existing row is modified in a monitored table.
Record deleted	onDelete	Fired when a row is deleted from a monitored table.

See the Trigger Reference for listener configuration, service callbacks, and the row record passed to each callback.

Documentation

• Setup Guide: Walks you through setting up an Oracle Database instance and obtaining the connection details required to use the Oracle DB connector, including optional configuration for Change Data Capture (CDC).

• Action Reference: Full reference for all clients: operations, parameters, return types, and sample code.

• Trigger Reference: Reference for event-driven integration using the listener and service model.

• Example: Learn how to build and configure an integration using the Oracle DB connector, including connection setup, operation configuration, and execution flow. For the listener and service model, see Trigger Reference.

How to contribute

As an open source project, WSO2 welcomes contributions from the community.

To contribute to the code for this connector, please create a pull request in the following repository.

• Oracle DB Connector GitHub repository

Check the issue tracker for open issues that interest you. We look forward to receiving your contributions.