This discussion is archived
2 Replies Latest reply: May 24, 2011 11:53 PM by 864253 RSS

SQL Developer Export Limitation of CLOB columns

745762 Newbie
Currently Being Moderated
Hello Everyone,

Would anyone happen to know if there is a column size limitation when exporting data (excel, text, etc) from the results query results pane? There appears to be a 4000 byte limitation. Specifically, I am attempting to export sql results that contain clobs which are storing XML messages.

Is this a known limitation and if so, is there any expectation of this being enhanced?

I am using the following:
Windows XP SP3
SQL Developer 2.1.0.63 (also happens on the 1.5 branch)
Oracle Server 10.2.0.4
Oracle Client 10.2.0.1

Thanks,
Ronnie

Legend

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