Now can short but not a long at 01704
CodePudding user response:
Is no to_blob function, or this function has no actual meaning,Write SQL directly, either select or update, appear in the string, as long as the two quotes directly more than 4000 characters, no matter how you convert, can direct error,
Solve this problem, need to write code block, give you an example, according to the change,
If need to modify the table TABLE_NAME, AAA field, this field is CLOB types,
DECLARE
CLOB_AAA TABLE_NAME. AAA % TYPE;
The BEGIN
CLOB_AAA:='here is you need to update the value of the';
- the back condition, can according to the actual need to fill in,
The UPDATE TABLE_NAME T SET T.A AA=CLOB_AAA WHERE ROWID=? ;
COMMIT;
END;
If need to modify multiple tables, directly in the BEGIN and END can be added directly,