DB Link from Sybase to Oracle 10g - Issue converting Varchar
Posted on 2006-11-14
I have a link from a Sybase database to an Oracle database.
We are having an issue converting data for one of the varchar fields. The Sybase field is defined as Varchar with 1000 char limit. The Oracle field is defined as Varchar with 1000 limit. We are seeing all records fail to move to the target Oracle column that are over 260 characters. It seems there may be some kind of data type conversion issue or issue in the gateway or link.
Does anyone know of any issues with Sybase to Oracle links and Varchars?