This content has been marked as final. Show 3 replies
Quite a few years ago there was a bug involving slow performance and/or Java OutOfMemoryException when displaying MySQL BLOBs, probably due to some issue with the MySQL JDBC driver. The bug was addressed back in SQL Developer 1.2.26.09 and is...
Bug 5904607 - MYSQL RUN SCRIPT PERFORMANCE FROM WORKSHEET NOT SATISFACTORY
At that time, a 4000 character display column size limit was added to circumvent the problem. It still remains and has not received much attention -- perhaps since VARCHAR2 is also limited to 4000, at least through the Oracle 11g releases.
In your specific case, you are not reaching the 4000 character limit. You can try the following in the worksheet:
show longwhich should show a default value of 80 if you never overrode it in your connection login script (Tools | Preferences | Database). So just
set long 4000and try running the script that outputs the XML again. Keep in mind that set long
Sets maximum width (in bytes) for displaying LONG, CLOB, NCLOB and XMLType values; and for copying LONG values.Possibly Bug 5904607 needs revisiting, but I hope the approach described will be sufficient to get you past the current problem.
SQL Developer Team