My Oracle Support Banner

Data Are Truncated when Loading a Microsoft SQL Server Table Using ODI (Doc ID 424141.1)

Last updated on DECEMBER 01, 2023

Applies to:

Oracle Data Integrator - Version 4.1.01.05 to 10.1.3.6.0
Information in this document applies to any platform.

Goal

An Integration Interface is used to load data into a Microsoft SQL Server 2000 table.
It appears that during the operation any column that exceeds 255 characters is truncated.
 
Inet JDBC Driver is used to access the RDBMS with the following URL :


The target server is Microsoft SQL Server 2000.

Solution

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.