Solved

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

Posted on 2006-11-14
3
850 Views
Last Modified: 2010-05-18
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
Comment
Question by:ntiguy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 17948597
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
 

Author Comment

by:ntiguy
ID: 17976579
Yes - When the data is under 260 characters the data will move without error.
0
 

Author Comment

by:ntiguy
ID: 17976587
The problem was found in the SP used to move the data.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question