• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 871
  • Last Modified:

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?

Thanks,

0
ntiguy
Asked:
ntiguy
  • 2
1 Solution
 
slightwv (䄆 Netminder) 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?
0
 
ntiguyAuthor Commented:
Yes - When the data is under 260 characters the data will move without error.
0
 
ntiguyAuthor Commented:
The problem was found in the SP used to move the data.
0
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.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now