Oracle Snap Pack
On this Page
Overview
Use the Oracle Snap Pack to connect to your Oracle database and achieve read and write access to its objects.
Use Snaps in this Snap Pack to:
Get a list of tables in a database.
Lookup records in the target table and returns 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.
JDBC Driver Upgrade 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 Upgrade from v11.2.0.4 to v19.20.0.0 and JOOQ Upgrade from v3.9.1 to 3.17.x. You can consume this driver upgrade with the Behavior Change 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. 434patches23000 Snap Pack version.
In this Section
- Oracle JDBC Driver Upgrade from v11.2.0.4 to v19.20.0.0 and JOOQ Upgrade from v3.9.1 to 3.17.x
- Table Creation
- Configuring Oracle Accounts
- Oracle - Bulk Load
- Oracle - Execute
- Oracle - Delete
- Oracle - Merge
- Oracle - Parallel Load
- Oracle - Stored Procedure
- Oracle - Table List
- Oracle - Lookup
- Oracle - Update
- Oracle - Select
- Oracle - Insert
Supported Versions
This Snap Pack is tested against Oracle version 19c.
This driver supports versions 11i, 12c, and 19c. Other versions may work, but that will be down to the compatibility of the Oracle JDBC driver.
Snap Pack History
Have feedback? Email documentation@snaplogic.com | Ask a question in the SnapLogic Community
© 2017-2025 SnapLogic, Inc.