<div>
Yes - When the data is under 260 characters the data will move without error.
</div>


Yes - When the data is under 260 characters the data will move without error.

<div>
The problem was found in the SP used to move the data.
</div>


The problem was found in the SP used to move the data.

<div>
<div class="content wysiwyg-content">
I have a link from a Sybase database to an Oracle database.<br />
<br />
We are having an issue converting data for one of the varchar fields. &nbsp;The Sybase field is defined as Varchar with 1000 char limit. &nbsp;The Oracle field is defined as Varchar with 1000 limit. &nbsp;We are seeing all records fail to move to the target Oracle column that are over 260 characters. &nbsp;It seems there may be some kind of data type conversion issue or issue in the gateway or link.<br />
<br />
Does anyone know of any issues with Sybase to Oracle links and Varchars?<br />
<br />
Thanks,<br />
<br />

</div>
</div>


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,



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

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.