I just tried this with no problems. My CLOB had 6,000+ characters in it. What about yours?
There was a bug in 4.2 with exporting data to JSON with CLOBs, but that's not what you're doing is it?
Show us the dialog that shows the contents of the column you are talking about.
Only YOU can do some troubleshooting. Break the problem into SMALL pieces.
Query only ONE row.
Query only that one COLUMN.
Query a similar column that has SMALL data.
Do some tests - post the results.
AS well as following the advise from rp0428 and answering thatjeffsmith's questions, please respond to below.
1. Are you running 32bit or 64bit OS?
2. Are you running 32bit or 64bit SQL Developer?
3. Did you install the version "with JDK included"?
4. If your answer is NO ifor question 3. then what version of java are you running?
5. What version of SQL Developer are you running specifically, 4.2.0.???.????
6. How big is large? Define it in bytes or characters, how big the CLOB is that gets truncated.
7. How much data is copy/pasted when you copy/paste?
8. Does your CLOB data contain special characters, CHR(0) for instance?
9. Give specific steps you are doing to "export" the data.
Nine points, please make an effort to answer all points, as they may have a baring on what you are experiencing.
This problem was present i the "4.2 early adopter" version, but has been corrected in the 4.2 release.
Please confirm which exact version you are using and whether upgrading to the lastes official release solves your problem.