If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

=====>> so, going bigger than this in normally demands ANOTHER tool/language, not PL/SQL nor direct SQL... Granted, the LONG datatype goes until 4 Gb, BUT the SQL and PL/SQL languages have smaller limits , yes - IF you want more than this, forget SQL and PL/SQL, and go for Java and OCI-like tools , as pro*c ...
Knowing this (and a awful lot of OTHER problems with LONGs), Oracle DE-SUPORTED LONGs some years ago, and introduced LOBs, for LOBs yes, we have the WRITE_APPEND routine in the DBMS_LOB package , it permits writing to the full LOB size.