This discussion is archived
3 Replies Latest reply: Jan 17, 2013 10:31 PM by kgronau RSS

SQL Developer truncates column data when accessing data from Sybase DB

user2220 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points