Updating a clob

Posted by / 16-Jan-2018 06:31

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.

Just strange that the insert works, and the variable assignment has some type of limitation when both values are basically 32k, not greater than. COUNT 33 INSERT INTO test1 VALUES v_data_record(x); 34 END; 35 / PL/SQL procedure successfully completed.

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 want to replace the value with my own short URL string.

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.

Error code: 24,816, Error message: ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column.

' '; END LOOP; Basically concatenating a long string, making it delimited for the application to parse. COUNT INSERT INTO monthly_mf_snapshot VALUES v_mf_record(x); BUT!

updating a clob-38updating a clob-87updating a clob-39

CLOB) Trans Log_Transaction Log_1Transaction Log()T r ansaction()Any(); You are Typecasting the string.