Updating a clob
DATA_TABLE " " "(ID, NAME, DESC, CLOB_FIELD) " "VALUES (?
The code above works just fine so long as v_query Answer: You may want to use a CLOB datatype for this.
A requirement that comes up a lot is the need to store strings longer than 4000 characters in the database, and this presents a problem.
Up to and including Oracle 11g R2 the longest varchar2 that can be stored in the database is 4000 characters.
I have heard that will change to 32K characters in Oracle 12c, but that hasn't been released yet, and when it is, it will be some time before it is widely adopted.
For this post, I am not concerned about storing strings that are many mega or gigabytes long - I am more interested in strings that are generally a few thousand characters up to about 32kb in size.