We edit CLOB columns through SQL Navigator, by double clicking on the column and pasting text into the CLOB editor.
However, when the source that we copy into the CLOB column contains a line of more than 1024 characters, it truncates the row.
Attached are 2 notepad files. We take the text just as they appear in both and copy them into the CLOB column. You will see that in 2nd file, the lines of texts are significantly longer.
- works fine in 6.2.1
- doesn’t work in 6.2.1
This has always worked perfectly in Navigator 5 and as a workaround we use Nav 5 to edit our CLOB columns.
Is there’s a limit on the number of characters in a row that you can put in the CLOB editor? Is there a setting that controls this?
Thanks in advance!
works fine.txt (10.4 KB)
doesn’t work.txt (9.14 KB)