"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 DECEMBER 18, 2023

Applies to:

Oracle Data Integrator - Version 3.2.03.01 to 10.1.3.9.99
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

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!

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

"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)

Applies to:

Symptoms

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

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!