3 Replies Latest reply: Jan 18, 2013 12:31 AM by Kgronau-Oracle RSS

    SQL Developer truncates column data when accessing data from Sybase DB

    user7417334
      Hello All,
      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 ?

      Thanks