Map Sql Parameter Source in = new Map Sql Parameter Source(); Value("id", id); Value("description", new Sql Lob Value( description, new Default Lob Handler()), Types.
I have a table with logs, I was wondering if it was possible to append data to my clob fields in existing rows?
In pseudo SQL what I want to do is the following: UPDATE tbl Log SET c Log = (c Log 'new logtext') WHERE id = 1 Thanks in advance Thank you for your answer, I tried to do as you suggested, but I get an "inconsistent datatypes" error msg.
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.
I'll have a look on my database setup next, maybe the error is there .. Originally posted by Zellez Thanx for the quick reply, I do the EXACT same thing as you do r123456 (created table c with var CLOB etc.), but still get the "inconsistent datatype" error. The thought crossed my mind, that would leave me with a problem tho, what use are a 2GB CLOB field if you cannot put more than 4k chars in it, and cannot append to it later?
I'll have a look on my database setup next, maybe the error is there .. My current approach is using SQL, maybe I have to code some oracle specific procedure to be able to accomplish my goal?Oracle recommends using CLOB instead of LONG for columns in the database. Using CLOB is a lot easier than trying to manipulate LONG. But there is something about using CLOBs that I didn't know.As you might have guessed from the title it has to do with NULL...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.We are talking rather large amounts of data, so I cannot just retrieve the data, append to it in code and repost it (my Oracle 8i driver has a 4000 char limit).