My Oracle Support Banner

"java.lang.NumberFormatException" or "Cannot start execution" or "com.sunopsis.jdbc.driver.file.d.i" Signaled when Using Oracle LOB Family Column Types in ODI Datastores and Integration Interfaces (Doc ID 423909.1)

Last updated on OCTOBER 04, 2022

Applies to:

Oracle Data Integrator - Version 3.2.03.01 and later
Information in this document applies to any platform.

Symptoms

When using Oracle Data Integrator (ODI) to reverse engineer a Datastore or to insert/update a Datastore containing a LOB family type object (such as a CLOB or BLOB), the following messages may be signaled:

Case 1. When displaying the data (right-click > data) from ODI Designer

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
 Case 1. When displaying the data (right-click > data) from ODI Designer
 Case 2. When running an ODI Integration Interface
 Case 3. When running an ODI Integration Interface that unloads CLOB data from Oracle to File
Changes
Cause
Solution
 Case 1. When displaying the data (right-click > data) from ODI Designer
 Case 2. When running an ODI Integration Interface
 Case 3. When running an ODI Integration Interface that unloads CLOB data from Oracle to File
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.