Oracle Snap Pack

Overview

Use the Oracle Snap Pack to connect to your Oracle database and perform any of the following operations:

Get a list of tables in a database.
Look up records in the target table and return a selected set of fields.
Fetch data from a database.
Execute SQL statements to delete, update, merge, or insert data within a specified table.
Execute a stored procedure.
Bulk Load or Parallel Load data in a target table.

Important: JDBC Driver upgrade and behavior change

The Oracle JDBC Driver is upgraded from OJDBC6 JAR (v11.2.0.4) to OJDBC10 JAR (v19.20.0.0) in the latest distribution in October 2023 and deployed to the stable distribution in the November 2023 release (after the Snaplex upgrade). The latest JDBC driver upgrade is backward-compatible. Learn more: Oracle JDBC driver and JOOQ upgrades.

You can consume this driver upgrade with the 434patches23000 Snap Pack version.

This JDBC driver upgrade has resulted in specific behavior changes that include errors, status codes, and success and failure messages. Learn more about the behavior changes to ensure your migration to the upgraded driver is seamless.

Prerequisites

An Oracle database instance (versions 11i, 12c, or 19c).
Database credentials with appropriate permissions for the operations you want to perform.

Supported versions

This Snap Pack is tested against Oracle version 19c. The driver supports versions 11i, 12c, and 19c. Other versions may work, but compatibility depends on the Oracle JDBC driver.