Analysis of OracleORA-01704: stringliteraltoolong

Today, when using SQL in oracle direct insertupdate for a table, the error of ORA-01704: stringliteraltoolong occurs, and our SQL is updatemall_confi

The error of ORA-01704: string literal too long occurs when SQL is used to insert update a table directly in oracle today, our SQL is update mall_confi

When using SQL to insert update a table directly in Oracle today, the error of ORA-01704: string literal too long occurs. Our SQL is

Among them, the category_info field is of the clob type, and the subsequent string content is very long. Although clob can be enough to save such a long string, the Syntax Parsing of SQL statements limits the field length, the text string is too long!

There are two solutions:

1. Use the stored procedure to save ultra-long text in a variable, and then insert update

2. concatenate strings and use strings for update.

This can solve the problem.