I was trying to insert a very large string into a CLOB using dbeaver and it kept failing (because of some oracle char limitation ) anyway easy solution insert it using Oracle SQL Developer (using the table editor), I think it must chunk it somehow in the background.