Limit on CLOB datatype in Oracle 10g
In Oracle 10g, does the 32K limit on the CLOB datatype still apply?
In Oracle 10g, the CLOB datatype can store up to (4GB-1)*(the value of the CHUNK parameter). If the CHUNK parameter is not explicitly set, the CLOB datatype can store up to (4GB-1)*(database block size).
In Oracle 8i and 9i, the CLOB datatype is restricted to 4GB in size.
The above can all be verified in the SQL Reference manual under Datatypes. You can find these manuals at http://tahiti.oracle.com.