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.
Supported Versions
This Snap Pack by default uses the Oracle 11i JDBC driver. This driver supports versions 11i and 12c. Other versions may work, but that will be down to the compatibility of the Oracle JDBC driver.
This Snap Pack is tested against Oracle 11.2.0.4.0.
| Panel | ||||
|---|---|---|---|---|
| ||||
Pages in this Section
|
| title | Snap Pack History |
|---|
4.16 Patch MULTIPLE7123
- Added two new properties, Number of retries and Retry interval, to Delete, Insert, Select, Execute, Merge, and Update Snaps that enables you to handle retry attempts during a connection failure.
4.16 Patch db/oracle6919
- Added a new property, Session parameters, in the Oracle Insert Snap to enable the use of National Language Support (NLS) parameters.
4.16 Patch db/oracle6824
- Fixed an issue with the Lookup Snap passing data simultaneously to output and error views when some values contained spaces at the end.
4.16 (snapsmrc508)
- No updates made. Automatic rebuild with a platform release.
4.15 Patch db/oracle6534
- Improved performance in Pipelines that contain child Pipelines.
4.15 Patch db/oracle6417
- Fixed an issue with data types conversion. All fields with byte, short, int, or long data types will be converted to BigInteger after fetching.
4.15 Patch db/oracle6284
- Replaced the existing Max idle time and Idle connection test period properties with Max life time and Idle Timeout properties respectively, in the Account configuration. The new properties fix the connection release issues that were occurring due to default/restricted DB Account settings.
4.15 (snapsmrc500)
- No updates made. Automatic rebuild with a platform release.
4.14 (snapsmrc490)
- No updates made. Automatic rebuild with a platform release.
4.13 Patch db/oracle5192
- Fixed the Oracle Bulk Load Snap that stores special characters incorrectly in the target table.
- Fixed the Oracle Bulk Load Snap that throws a
NullPointerExceptionerror when the input letter case does not match with that of the Oracle table.
4.13 (snapsmrc486)
- No updates made. Automatic rebuild with a platform release.
4.12 Patch oracle4862
- Fixed an issue in the Oracle Bulk Load Snap that fails to execute the SQLLDR (SQL Loader) command, while also enhancing the support for the TCPS protocol.
4.12 Patch db/oracle4721
- Added a property, "SSL/TCPS" for Oracle Account.
4.12 Patch MULTIPLE4744
- Enabled expression for Delete Condition in Oracle Delete Snap.
4.12 (snapsmrc480)
- No updates made. Automatic rebuild with a platform release.
4.11 Patch db/oracle4369
- Enhanced the Oracle Bulk Load Snap to accept date-type values in the format "yyyy-mm-dd".
4.11 (snapsmrc465)
- No updates made. Automatic rebuild with a platform release.
4.10 Patch oracle3633
- Fixed BULK LOAD so it adds the thread name to the name of the temporary directory. This allows multiple BULK LOAD Snaps within a single pipeline.
4.10 (snapsmrc414)
- Added Auto commit property to the Select and Execute Snaps at the Snap level to support overriding of the Auto commit property at the Account level.
4.9.0 Patch oracle3188
- Fixed the issue that "NaN" check was done to unexpected data types like varchar
4.9.0 Patch oracle3096
- Fixed a class casting issue for custom data types(BLOB, CLOB, NCLOB, etc) when custom Oracle JDBC driver is used
4.9.0 Patch oracle3071
- Fixed an issue regarding connection not closed after login failure; Expose autocommit for "Select into" statement in PostgreSQL Execute Snap and Redshift Execute Snap
4.9.0 (snapsmrc405)
- No updates made. Automatic rebuild with a platform release.
4.8.0 Patch oracle2905
- Fix for SQL*Loader interpreting white-space only data as null values.
4.8.0 Patch oracle2756
- Potential fix for JDBC deadlock issue.
4.8.0 Patch oracle2711
- Fixed Oracle Snap Pack rendering dates that are one hour off from the date returned by database query for non-UTC Snaplexes.
4.8.0 (snapsmrc398, changed to oracle2905 on April 20, 2017)
- Database accounts now invalidate connection pools if account properties are modified and login attempts fail.
4.7.0 Patch oracle2190
- Fixed an issue for database Select Snaps regarding Limit rows not supporting an empty string from a pipeline parameter.
4.7.0 (snapsmrc382)
- Updated the Oracle - Stored Procedure Snap with the Pass through field.
- Resolved an issue in Oracle - Stored Procedure Snap that caused invalid column type failures.
- Oracle - Bulk Load updated to handle dates the same way as Oracle - Insert. Acceptable format for timestamp strings:
Prior to 4.7, the only acceptable timestamp format was "yyyy-mm-dd hh:mm:ss.SSS", such as 2016-11-07 10:55:12
It now also supports:
ISO8601 formats (plus fractional seconds) without timezone.
"yyyy-mm-ddThh:mm:ss.SSS", (ex: 2016-11-07T10:55:12)
"yyyymmddThhmmss.SSS", (ex: 20161107T105512)ISO8601 formats with time zone. ONLY 'zulu' and 'UTC' at this time. Note that there is no space before the 'Z' but is a space before the 'UTC'.
"yyyy-mm-ddThh:mm:ss.SSSZ"
"yyyymmddThhmmss.SSSZ""yyyy-mm-ddThh:mm:ss.SSS UTC"
"yyyymmddThhmmss.SSS UTC"ex: 2016-11-07T10:55:12Z
ex: 20161107T105512Zex: 2016-11-07T10:55:12 UTC
ex: 20161107T105512 UTCThe ISO8601 format is used by many web services, Oracle Bulk Loader, and others.
4.6.0 Patch oracle1987
- Resolved an issue with Oracle Stored Procedure Snap for an IN OUT NUMBER parameter taking an input value of null.
4.6.0 (snapsmrc362)
- Resolved an issue in Oracle Select Snap that caused failures in the second output view when retrieving outputs from a table with a dot (.) character.
- Enhanced the Oracle Select Snap to fully support SQL statements with/without expressions & SQL bind variables.
- Extended support for Oracle Thin Dynamic accounts.
4.5.1 (oracle1583)
- Updated the Bulk Load Snap with a new field, Use direct path load, to enhance bulk loading performance.
- Resolved an issue with Oracle Select Snap failing if the table name included a dot (.) character.
4.5 (snapsmrc344)
- Resolved an issue in Oracle Insert Snap to ensure that a string value, when inserted in a date column, is not converted to Null in Oracle database.
- Resolved an issue in Oracle Stored Procedure Snap that occurred while loading stored procedure name field's suggestions.
4.4.1
- Oracle Select: Resolved an issue with database access error occurring while iterating over table name result set when using an uploaded driver with a different version than the bundled driver.
- Resolved an issue with Oracle Stored Procedure Snap not accepting CLOB data.
- Made improvements to JDBC auto-commit consistency.
4.3.2
- Resolved an issue with Oracle Select not reading table names: Database access error occurred while iterating over table name result set.
- Resolved an issue with Oracle Bulk load failure: String index out of range: -1.
4.3.1
- Resolved a database access error occurring while iterating over table name result set with the Oracle Select Snap.
4.3.0
- Table List Snap: A new option, Compute table graph, now lets you determine whether or not to generate dependents data into the output.
- Oracle Bulk Load
- Resolved an issue with a pipeline never completing.
- Resolved an issue with pipeline statistics, bulk load summary statistics not matching and bulk load summary was confusing.
- Maximum error count field added to set the maximum number of rows which can fail before the bulk load operation is stopped.
- Mixed-case matching option removed.
- Added error messaging to handle BLOB type data trying to be loaded to an Oracle table when not supported.
- Resolved an issue with the record separator of the input file not being processed correctly.
- Improved error messages for when data types do not match.
- Oracle Stored Procedure: All accessible objects are now visible during design.
4.2.2
- NEW! Oracle Bulk Load Snap
- Oracle Execute Snap: Columns now appear in the order of the select query.
- Addressed a memory issue in Oracle Stored Procedure Snap.
- Ignore empty result added to Execute and Select Snaps. The option will not write any document to the output view for select statements producing no results.
August 7, 2015 (2015.25/4.2.1)
- Oracle connection errors now route to error view.
- Output fields table property added to Select Snap.
- Resolved an issue in Execute and Select Snaps where the output document was the same as the input document if the query produces no data. When there is no result from the SELECT query, the input document will be passed through to the output view as a value to the 'original' key. The new property Pass through with true default.
June 27, 2015 (2015.22)
- Oracle Merge: SQL operation failed with an "IO Error: Connection reset, error code: 17002, SQL state: 08006 connection failure".
- JSON paths in WHERE clauses should be processed as bind values after the expression is evaluated.
June 6, 2015 (2015.20)
- Oracle Lookup failed in preview if DATE column was used for Lookup conditions
- Dynamic DB queries now supported in the Execute Snap.
- The SQL statement property now can be set as an expression property. When it is an expression, it will be evaluated with each input document and one SQL statement per each input document will be executed.
- Known issue: When the SQL statement property is an expression, the pipeline parameters are shown in the suggest, but not the input schema.
- With the SQL statement property set as an expression, the Snap can be exposed to SQL injection. Please use this feature with caution.
- Oracle Insert: When a string value is entered into a date col, its successfully inserting into db with null
- Oracle Stored Procedure: parameter type list was not populating even if a procedure had custom types defined.
May 15, 2015
- Oracle Execute error - no more documents will be written to SLFS
- Oracle Execute Snap failing with maximum number of documents reached
- Oracle Select Snap - Early dates are corrupted when reading data
- Oracle select- with date data type does not return Time(hh:mm:ss)
- Oracle Stored Procedure fails with error- Reason: invalid name pattern: TECTONIC.null
- Oracle Stored Procedure - fails with - "invalid name pattern: TECTONIC.strarray32 " when type name given in lower case
May 2, 2015
- Oracle: enhancements in dealing with DATE type fields
- Oracle Lookup: Pass-though on no lookup match property added to allow you to pass the input document through to the output view when there is no lookup matching.
March 2015
- Select: Resolved a null pointer exception and a failure with Suggest for Output fields and Lookup Column name properties with a synonym as a table name.
- Stored Procedure: Resolved issues where downstream Snaps were unable to execute when connected to an Oracle Stored Procedure not using the OUT parameter.
- Lookup: Resolved an issue with Output fields and Lookup Column name properties when a synonym was used as a table name.
January 2015
- Oracle Account: The settings Acquire increment and Retry Attempts were removed.
December 20, 2014
- Oracle Snap Pack: Lookup, Table list, Stored Procedure, Select Snaps added
October 18, 2014
On this Page
| Table of Contents |
|---|
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.
| Multiexcerpt macro | ||||||
|---|---|---|---|---|---|---|
| ||||||
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: You can consume this driver upgrade with the 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. |
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
In this Section
|
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
| Excerpt | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
