Snap Pack history: Oracle
|
|
|
Updates |
|---|---|---|---|
|
|
|
Fixed an issue with the Oracle - Insert, Oracle - Update, and Oracle - Merge Snaps, and the Generic JDBC - Insert , and Generic JDBC - Update Snaps (when connected to an Oracle database), that caused slow writes to NCLOB columns after the August 2026 release. The Snaps now behave as follows:
|
|
|
|
Updated and certified against the current SnapLogic Platform release. |
|
|
|
Enhanced the Oracle - Insert, Oracle - Update, Oracle - Delete, and Oracle - Merge Snaps by adding the
Session parameter type property with support for
STRING, INTEGER, and BOOLEAN
data types in session parameters. |
|
|
|
Upgraded the Apache CXF client library dependency across Snap Packs to the latest stable patch version (3.6.12) as part of the routine maintenance fixes and performance improvements. This update strengthens platform security with no changes needed to existing pipeline configurations or Snap behaviors. |
|
|
|
Updated and certified against the current SnapLogic Platform release. |
|
|
|
Fixed an issue where the Oracle - Insert, Oracle - Update, and Oracle - Merge Snaps failed with ORA-03146: invalid
buffer length for TTC field when attempting to write large NCLOB values (greater
than 32 KB). |
|
|
|
Updated and certified against the current SnapLogic Platform release. |
|
|
|
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. |
|
|
|
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. |
|
|
|
Updated and certified against the current SnapLogic Platform release. |
|
|
|
Updated and certified against the current SnapLogic Platform release. |
|
|
|
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. |
|
|
|
Updated and certified against the current SnapLogic Platform release. |
|
|
|
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. |
|
|
|
Updated and certified against the current SnapLogic Platform release. |
|
|
|
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). |
|
|
|
Updated and certified against the current SnapLogic Platform release. |
|
|
|
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. |
|
|
|
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. |
|
|
|
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. |
|
|
|
Fixed an issue with the Oracle - Execute Snap that displayed an error when handling OffsetDateTime type bindings. |
|
|
|
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. |
|
|
|
Fixed an issue with Oracle - Bulk Load Snap that intermittently displayed a null pointer exception. The exception is now replaced with ConfigurationException. |
|
|
|
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 |
|
|
|
Updated and certified against the current SnapLogic Platform release. |
|
|
|
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. |
|
|
|
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. |
|
|
|
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. |
|
|
|
Updated and certified against the current SnapLogic Platform release. |
|
|
|
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. |
|
|
|
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. |
|
|
|
The Oracle - Execute Snap now includes a new Query type field. When Auto is selected, the Snap tries to determine the query type automatically. |
|
|
|
Updated and certified against the current SnapLogic Platform release. |
|
|
|
Updated and certified against the current SnapLogic Platform release. |
|
|
|
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. |
|
|
|
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. |
|
|
|
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. |
|
|
|
The Oracle - Select Snap now work as expected when the table name is dependent on an upstream input. |
|
|
|
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. |
|
|
|
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. |
|
|
|
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). |
|
|
|
Updated and certified against the current SnapLogic Platform release. |
|
|
|
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 |
|
|
|
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. |
|
|
|
Updated and certified against the current SnapLogic Platform release. |
|
|
|
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. |
|
|
|
Updated and certified against the current SnapLogic Platform release. |
|
|
|
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. |