There seems to be a weird behaviour of SQL Developer, I'm trying to access Sybase data from Oracle Database with a DB link. My select returns correct data, but any column data coming from Sybase is truncated. For Example, A Project number column which is part of the query and fetching data from Sybase, Project number is 6 character in our system, SQL Developer brings only 4 characters.
To access Sybase we use DB Link from Oracle.
Anyone has come across of this kind of weird behaviour using SQL Developer?
Same Query when executed on Sql Prompt/ Rapid Sql works fine without any truncation.
Any suggestion ?
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.