Updating a clob


A direct insert into the table works for a value up to 32k, but storing it into that variable first gives me the error.

updating a clob-86updating a clob-10

when I did my Update string, I end up having problems within the application that is using the database, when I try to examine the record.I'm thinking it has to do with CLOB fields not allowing simple string updates. Can you show: - the structure of your table - the update you do Also what sort of "problem" do you have ?Unless you need to fill a CLOB with a very large value (larger than the maximum allowed for a varchar2), you can just update it using a simple update.Error code: 24,816, Error message: ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column.(CC_Ora Statement::execute Update, file CC_Ora Statement.cpp, line 2,382) Any suggestion is much appreciated,as its an hot topic in my project Thanks, Rani Try creating an user define update SQL by placing all the clob fields in the last and there should be not other update/insert fields after the clob fields.Here are the speed options for various insert methods: When storing a LOB, you can either load it inline, or leave it in a flat file and use BFILE: The landmark book "Advanced Oracle SQL Tuning The Definitive Reference" is filled with valuable information on Oracle SQL Tuning.

You must have an account to comment. Please register or login here!