This content has been marked as final. Show 3 replies
What's the source table definition (the definition of the Sybase table) and what product (DG4SYBS/DG4ODBC) do you use to link from your Oracle database to Sybase?
We use Oracle Gateway for Sybase. Oracle (10.2.0.3) and Sybase (12.0) and Gateway (9.2). About table definition, We are using custom build application in Sybase. Were the data needs to accessed from Oracle.
Unfortunately you didn't post the table description as it is defined on the Sybase side and which truncates the data. One possible root cause I could imagine might be a NLS issue (SQL Dev is commonly using Unicode NLS settings when connecting to the Oracle database), so getting the gateway init file would be helpful as well as the output of "select * from v$nls_parameters". Also a describe output using the gateway describing the remote table from SQL*Plus would be helpful: desc <your table>@<database link>
Please make sure to provide the source table description as well as the description using the gateway as in a Unicode env char/varchar/nchar/nvarchar columns might be trippled in its precision.