Your problem is not related to the size of the CLOB value. There is no object or system privilege that let's you insert small CLOB values but stops you from inserting larger CLOB values. Rather, it is more likely that your application connects as a different user than you did with SQL*Plus. The application connection does not have the appropriate privileges to be inserting anything to the CLOB column of the table.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.