This content has been marked as final. Show 2 replies
The behavior depends on the version of SQL Developer in use. Prior to 3.0, there was no limit imposed by SQL Developer, but attempting to view a large CLOB in the result grid's cell editor could result in a Java OutOfMemory error. Using 3.0 or higher, the limit is 2 GB (with a trailing "..." to indicate truncation), which I suppose could still result in an OutOfMemory depending on your Java VM's -Xmx setting.
And if you are trying to print out the CLOB in a script, here is a thread with a how-to on that:
Re: Scirpt output of CLOBs are truncated
SQL Developer Team