- May 2026
- main34730
- 13 May 2026
- Stable
|
- May 2026
- main34730
- 13 May 2026
- Stable
|
- May 2026
- main34730
- 13 May 2026
- Stable
|
Updated and certified against the current SnapLogic Platform release. |
- February 2026
- 443patches34627 | 444patches34629
- 28 Apr 2026
- Latest
|
- February 2026
- 443patches34627 | 444patches34629
- 28 Apr 2026
- Latest
|
- February 2026
- 443patches34627 | 444patches34629
- 28 Apr 2026
- Latest
|
Fixed an issue where Oracle Snaps failed when the node entered maintenance mode during a Snaplex version upgrade, rather than allowing the pipelines to complete. |
- January 2026
- 443patches33716
- 23 Jan 2026
- Latest
|
- January 2026
- 443patches33716
- 23 Jan 2026
- Latest
|
- January 2026
- 443patches33716
- 23 Jan 2026
- Latest
|
Fixed an issue in all Oracle Snaps (except the Oracle - Execute Snap) where CLOB data types were
incorrectly mapped as binary in the schema. CLOB fields are now correctly mapped as
strings in the schema view by aligning the common type-mapping logic. |
- November 2025
- main33142
- 12 Nov 2025
- Stable
|
- November 2025
- main33142
- 12 Nov 2025
- Stable
|
- November 2025
- main33142
- 12 Nov 2025
- Stable
|
Updated and certified against the current SnapLogic Platform release. |
- August 2025
- main32088
- 13 Aug 2025
- Stable
|
- August 2025
- main32088
- 13 Aug 2025
- Stable
|
- August 2025
- main32088
- 13 Aug 2025
- Stable
|
Updated and certified against the current SnapLogic Platform release. |
- May 2025
- 441patches31537
- 01 July 2025
- Latest
|
- May 2025
- 441patches31537
- 01 July 2025
- Latest
|
- May 2025
- 441patches31537
- 01 July 2025
- Latest
|
Fixed a null pointer exception issue in the Oracle - Execute Snap when the key or value in the URL
properties field in the Oracle Thin or Oracle Thin Dynamic Account was left
blank. |
- May 2025
- main31019
- 14 May 2025
- Stable
|
- May 2025
- main31019
- 14 May 2025
- Stable
|
- May 2025
- main31019
- 14 May 2025
- Stable
|
Updated and certified against the current SnapLogic Platform release. |
- February 2025
- 440patches30071
- 14 Apr 2025
- Latest
|
- February 2025
- 440patches30071
- 14 Apr 2025
- Latest
|
- February 2025
- 440patches30071
- 14 Apr 2025
- Latest
|
Fixed the Null Pointer Exception (NPE) issue in the Oracle Snaps. Now, these
Snaps display an exception error instead of NPE when the URL properties (key and
value) and either key or value are empty. |
- February 2025
- main29887
- 12 Feb 2025
- Stable
|
- February 2025
- main29887
- 12 Feb 2025
- Stable
|
- February 2025
- main29887
- 12 Feb 2025
- Stable
|
Updated and certified against the current SnapLogic Platform release. |
- November 2024
- 439patches29008
- 28 Nov 2024
- Latest
|
- November 2024
- 439patches29008
- 28 Nov 2024
- Latest
|
- November 2024
- 439patches29008
- 28 Nov 2024
- Latest
|
Fixed an issue with Oracle - Execute, Oracle - Select, and Oracle - Stored Procedure Snaps where the data was
displayed in an unexpected structure and without the actual row address value when
querying table columns of ROWID type. Now, the Snaps handle the ROWID type columns
correctly to prevent the display of the nested output when ROWID is combined in the
query with other selected columns.Breaking change:With the 439patches29008 Snap Pack
version if any of your existing Oracle pipelines use the encoded ROWID(by manually
handling the Base64 encoded data), your pipelines might break. To avoid potential
pipeline failures, it is recommended to downgrade your Snap Pack to the previous
version until the issue is resolved. Behavior change:Earlier, the ROWID columns were
displayed in binary (Base64 encoded data) form in the output. With the
439patches29008, the Oracle - Execute and Oracle - Select Snaps display the ROWID columns in
string form in the output (which can be used for other operations
downstream). |
- November 2024
- main29029
- 13 Nov 2024
- Stable
|
- November 2024
- main29029
- 13 Nov 2024
- Stable
|
- November 2024
- main29029
- 13 Nov 2024
- Stable
|
Updated and certified against the current SnapLogic Platform release. |
- August 2024
- 438patches27870
- 30 Aug 2024
- Latest
|
- August 2024
- 438patches27870
- 30 Aug 2024
- Latest
|
- August 2024
- 438patches27870
- 30 Aug 2024
- Latest
|
Fixed an issue with the Oracle - Merge Snap
that caused a date format error when the merge condition was used with the TO_DATE()
function. |
- August 2024
- main27765
- 21 Aug 2024
- Stable
|
- August 2024
- main27765
- 21 Aug 2024
- Stable
|
- August 2024
- main27765
- 21 Aug 2024
- Stable
|
Added Oracle - Parallel Load Snap that executes
a high-performance data load by inserting data in parallel across multi-threaded
tasks.Enhanced the Oracle Insert, Merge, Update, and Delete Snaps to support the
Enable, Disable, and Force commands in the Session parameters that enable you to
dynamically manage specific session settings. |
- Jun 2024
- 437patches26651
- 12 June 2024
- Latest
|
- Jun 2024
- 437patches26651
- 12 June 2024
- Latest
|
- Jun 2024
- 437patches26651
- 12 June 2024
- Latest
|
Enhanced the Oracle Thin and Oracle Thin Dynamic Accounts to support Kerberos
authentication for Oracle databases on Windows and Linux systems.Enhanced the Oracle - Delete Snap with the Session parameters field
set that provides National Language Support (NLS). Learn more about Setting NLS
Parameters. |
- May 2024
- 437patches26346
- 14 May 2024
- Latest
|
- May 2024
- 437patches26346
- 14 May 2024
- Latest
|
- May 2024
- 437patches26346
- 14 May 2024
- Latest
|
Fixed an issue with the Oracle - Execute Snap
that displayed an error when handling OffsetDateTime type bindings. |
- May 2024
- main26341
- 08 May 2024
- Stable
|
- May 2024
- main26341
- 08 May 2024
- Stable
|
- May 2024
- main26341
- 08 May 2024
- Stable
|
Updated the Delete Condition (Truncates a Table if empty) field in the Oracle - Delete Snap to Delete condition (deletes all
records from a table if left blank) to indicate that all entries will be deleted
from the table when this field is blank, but no truncate operation is
performed. |
- February 2024
- 436patches26208
- 26 Apr 2024
- Latest
|
- February 2024
- 436patches26208
- 26 Apr 2024
- Latest
|
- February 2024
- 436patches26208
- 26 Apr 2024
- Latest
|
Fixed an issue with Oracle - Bulk Load Snap
that intermittently displayed a null pointer exception. The exception is now
replaced with ConfigurationException. |
- February 2024
- 436patches25696
- 02 Apr 2024
- Latest
|
- February 2024
- 436patches25696
- 02 Apr 2024
- Latest
|
- February 2024
- 436patches25696
- 02 Apr 2024
- Latest
|
Fixed an issue with the Oracle - Bulk Load Snap
to handle the type definition of nvarchar and nchar data types by defining them in
the control file of the SQL loader.Fixed an issue with the Oracle - Bulk Load Snap that incorrectly incremented
the year part of the DATE datatype for specific datasets.Fixed an issue with the Oracle - Merge Snap that did not handle the timestamp
conversion correctly when the time was not in the hh:mm format and had single digits
(for example, 1:9) in the timestamp.The Oracle - Execute Snap displays both the status and the
message in the output when you call stored procedures.Behavior Change:As part of
436patches25696, when you use a stored procedure in the Oracle - Execute Snap, the Snap displays Message:
Success and $UPDATE_COUNT=-1, 0, or 1 (based on the Snap Pack behavior) in the
output |
- February 2024
- main25112
- 14 Feb 2024
- Stable
|
- February 2024
- main25112
- 14 Feb 2024
- Stable
|
- February 2024
- main25112
- 14 Feb 2024
- Stable
|
Updated and certified against the current SnapLogic Platform release. |
- November 2023
- 435patches24769
- 30 Jan 2024
- Latest
|
- November 2023
- 435patches24769
- 30 Jan 2024
- Latest
|
- November 2023
- 435patches24769
- 30 Jan 2024
- Latest
|
Fixed an issue with the Oracle Snap Pack that required the i18n extensions to
be present when the Oracle database instance was in a specific language. |
- November 2023
- 435patches24445
- 19 Jan 2024
- Latest
|
- November 2023
- 435patches24445
- 19 Jan 2024
- Latest
|
- November 2023
- 435patches24445
- 19 Jan 2024
- Latest
|
Enhanced the Oracle - Execute, Oracle - Select, and Oracle - Lookup Snaps with a Column-specific timestamp
precision checkbox to represent column-specific timestamp precision for the string
data type.The Oracle - Insert, Oracle - Update, and Oracle - Bulk Load Snaps now support up to nanosecond
precision for the string data type. |
- November 2023
- 435patches23823
- 20 Nov 2023
- Latest
|
- November 2023
- 435patches23823
- 20 Nov 2023
- Latest
|
- November 2023
- 435patches23823
- 20 Nov 2023
- Latest
|
Fixed an issue with the Oracle - Stored Procedure Snap that displayed an error (SnapDataException) when custom JAR files were used
in the Oracle Accounts.Fixed an issue with the Oracle - Stored Procedure Snap that displayed an error
when custom JAR files were used for BLOB and CLOB datatypes in the Oracle
Accounts. |
- November 2023
- main23721
- 08 Nov 2023
- Stable
|
- November 2023
- main23721
- 08 Nov 2023
- Stable
|
- November 2023
- main23721
- 08 Nov 2023
- Stable
|
Updated and certified against the current SnapLogic Platform release. |
- August 2023
- 434patches23000
- 13 Oct 2023
- Latest
|
- August 2023
- 434patches23000
- 13 Oct 2023
- Latest
|
- August 2023
- 434patches23000
- 13 Oct 2023
- Latest
|
The JDBC driver for the Oracle Snap Pack is upgraded from OJDBC6 JAR
(v11.2.0.4) to OJDBC10 JAR (v19.20.0.0) in the latest distribution in October 2023
and will be deployed to the stable distribution in the November 2023 release (after
the Snaplex upgrade). This upgrade changes specific error codes and status messages.
The latest JDBC driver upgrade is backward-compatible. Learn more: Upgrading from
Oracle JDBC 11.2.0.4 Driver to 19.20.0.0 Driver. |
- August 2023
- 434patches22787
- 08 Sep 2023
- Latest
|
- August 2023
- 434patches22787
- 08 Sep 2023
- Latest
|
- August 2023
- 434patches22787
- 08 Sep 2023
- Latest
|
Fixed an issue with the Oracle - Bulk Load Snap
that was not resilient to the errors previously when trying to auto-discover the
existing SQLLDR utility paths in the node. The Snap is now robust to those
errors. |
- August 2023
- main22460
- 16 Aug 2023
- Stable
|
- August 2023
- main22460
- 16 Aug 2023
- Stable
|
- August 2023
- main22460
- 16 Aug 2023
- Stable
|
The Oracle - Execute Snap now includes a new
Query type field. When Auto is selected, the Snap tries to determine the query type
automatically. |
- May 2023
- main21015
- 10 May 2023
- Stable
|
- May 2023
- main21015
- 10 May 2023
- Stable
|
- May 2023
- main21015
- 10 May 2023
- Stable
|
Updated and certified against the current SnapLogic Platform release. |
- February 2023
- main19844
- 09 Feb 2023
- Stable
|
- February 2023
- main19844
- 09 Feb 2023
- Stable
|
- February 2023
- main19844
- 09 Feb 2023
- Stable
|
Updated and certified against the current SnapLogic Platform release. |
- November 2022
- 431patches19781
- 09 Feb 2023
- Latest
|
- November 2022
- 431patches19781
- 09 Feb 2023
- Latest
|
- November 2022
- 431patches19781
- 09 Feb 2023
- Latest
|
The Oracle - Stored Procedure Snap works as
expected and does not fail with the error Invalid value type when you pass BLOB data
as a parameter to the stored procedure with BLOB datatype. |
- November 2022
- 431patches19275
- 14 Dec 2022
- Latest
|
- November 2022
- 431patches19275
- 14 Dec 2022
- Latest
|
- November 2022
- 431patches19275
- 14 Dec 2022
- Latest
|
The Oracle - Stored Procedure Snap now supports
stored functions with OUT and INOUT parameters and displays these parameter values
in the output along with the returnval key. |
- November 2022
- main18944
- 10 Nov 2022
- Stable
|
- November 2022
- main18944
- 10 Nov 2022
- Stable
|
- November 2022
- main18944
- 10 Nov 2022
- Stable
|
The Oracle - Insert Snap now creates the target
table only from the table metadata of the second input view when the following
conditions are met:The Create table if not present checkbox is selected.The target
table does not exist.The table metadata is provided in the second input
view. |
- September 2022
- 430patches17894
- 16 Sep 2022
- Latest
|
- September 2022
- 430patches17894
- 16 Sep 2022
- Latest
|
- September 2022
- 430patches17894
- 16 Sep 2022
- Latest
|
The Oracle - Select Snap now work as expected
when the table name is dependent on an upstream input. |
- August 2022
- 430patches17658
- 07 Sep 2022
- Latest
|
- August 2022
- 430patches17658
- 07 Sep 2022
- Latest
|
- August 2022
- 430patches17658
- 07 Sep 2022
- Latest
|
The Oracle - Stored Procedure Snap now takes
lesser time to execute when calling a stored procedure, because the Snap queries the
metadata as required, thereby optimizing the Snap's performance. |
- August 2022
- main17386
- 11 Aug 2022
- Stable
|
- August 2022
- main17386
- 11 Aug 2022
- Stable
|
- August 2022
- main17386
- 11 Aug 2022
- Stable
|
Enhanced the Oracle - Merge and Oracle - Update Snaps with the Session parameters
fieldset that provides National Language Support (NLS).Enhanced the Oracle - Stored Procedure Snap with a process that
caches the fetched procedure metadata. Hence, the Snap processes the metadata calls
only for the first few documents and does not process for subsequent documents,
thereby improving the Snap's performance. |
- 4.29 Patch
- 429patches16603
- 29 Jun 2022
- Latest
|
- 4.29 Patch
- 429patches16603
- 29 Jun 2022
- Latest
|
- 4.29 Patch
- 429patches16603
- 29 Jun 2022
- Latest
|
Fixed an issue with Oracle - Bulk Load Snap
where the Snap encountered an error when trying to load data into
Timestampwithtimezone datatype field.Fixed an issue with Oracle - Execute Snap where the Snap did not display a
valid error message when the delete condition was invalid.Fixed an issue with Oracle - Merge Snap where the Snap displayed an error
when the Retry Interval and Number of Retries fields were expression enabled and the
values were passed using the Pipeline parameters.Fixed an issue with the Oracle - Stored Procedure Snap where the Snap errored
out due to an upgrade made to HikariCP that caused a conditional failure and
prevented the downstream Snaps to supply the parameters to the stored procedure.
Enhanced the Oracle - Merge and Oracle - Update Snaps with the Session Parameters
fieldset that provides National Language Support (NLS). |
- 4.29
- main15993
- 14 May 2022
- Stable
|
- 4.29
- main15993
- 14 May 2022
- Stable
|
- 4.29
- main15993
- 14 May 2022
- Stable
|
Updated and certified against the current SnapLogic Platform release. |
- 4.28
- main14627
- 12 Feb 2022
- Stable
|
- 4.28
- main14627
- 12 Feb 2022
- Stable
|
- 4.28
- main14627
- 12 Feb 2022
- Stable
|
Enhanced the Oracle - Update Snap to accept
values in the Number of Retries and Retry Interval (seconds) fields from Pipeline
parameters only. Enhanced the Oracle Bulk Load Snap with the Column Length Overrides
field set to support CLOB (Character Large Object) and NCLOB (National Character
Large Object) data types that may require a large buffer size, allowing users to
load large amounts of data into a single column store of data type CLOB or
NCLOB.Updated the label for Delete Condition to Delete Condition (Truncates Table if
empty) in the Snap Oracle Delete Snap |
- 4.27
- main12833
- 13 Nov 2021
- Stable
|
- 4.27
- main12833
- 13 Nov 2021
- Stable
|
- 4.27
- main12833
- 13 Nov 2021
- Stable
|
Enhanced the Oracle - Execute Snap to invoke
stored procedures.Enhanced the Oracle - Bulk Load
Snap with Additional SQL Loader Parameters field set to define additional SQL Loader
parameters if required. |
- 4.26
- main11181
- 14 Aug 2021
- Stable & Latest
|
- 4.26
- main11181
- 14 Aug 2021
- Stable & Latest
|
- 4.26
- main11181
- 14 Aug 2021
- Stable & Latest
|
Updated and certified against the current SnapLogic Platform release. |
- 4.25 Patch
- 425patches11008
- 04 Aug 2021
- Latest
|
- 4.25 Patch
- 425patches11008
- 04 Aug 2021
- Latest
|
- 4.25 Patch
- 425patches11008
- 04 Aug 2021
- Latest
|
Improved the support for the CLOB data type in the Oracle - Insert Snap. Improved the error messages for
all the Snaps in the Oracle Snap Pack where the Snaps fail with Null Pointer
Exception when the account reference provided is invalid. |
- 4.25
- main9554
- 08 May 2021
- Stable
|
- 4.25
- main9554
- 08 May 2021
- Stable
|
- 4.25
- main9554
- 08 May 2021
- Stable
|
Updated and certified against the current SnapLogic Platform release. |
- 4.24
- main8556
- 13 Feb 2021
- Stable
|
- 4.24
- main8556
- 13 Feb 2021
- Stable
|
- 4.24
- main8556
- 13 Feb 2021
- Stable
|
Enhances the Oracle - Select Snap to return
only the selected output fields or columns in the output schema (second output view)
using the Fetch Output Fields In Schema check box. If the Output Fields field is
empty all the columns are visible. Enhances the Oracle - Stored Procedure Snap to ignore the
parameters evaluated as null by using the Ignore Null Parameters check box. This
applies to parameters with defined default values. |
