DB Link from Sybase to Oracle 10g - Issue converting Varchar

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?


Who is Participating?
slightwv (䄆 Netminder)Connect With a Mentor Commented:
First I'm not a Sybase person so I won't be able to provide a silver bullet but my guess is that the Oracle database is set up with a Multi-Byte character set.  The 260 number bothers me a bit.  Are you saying it works with 259 characters and fails with 260?
ntiguyAuthor Commented:
Yes - When the data is under 260 characters the data will move without error.
ntiguyAuthor Commented:
The problem was found in the SP used to move the data.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.