When inserting a text or an HTML string directly through an INSERT statement, more than 4000 characters are reported:
ORA-01489: String concatenated result is too long
Although the field is CLOB, it is sufficient to store it, but by this direct insertion, because there is no mandatory designation with the insertion string as the CLOB type,
Oracle handles the inserted string as a "string type", which causes an error because Oracle has the maximum string limit (no more than 4,000 characters).
Workaround: Specify the string type to be inserted as Clob, and the long string into the CLOB variable, which can be used by a procedure or stored procedure
Example:
DECLARE
Reallybigtextstring CLOB: = ' massive string to be inserted ';
BEGIN
INSERT into test_table VALUES (' Test ', reallybigtextstring, ' 0 ');
End;
Commit
This will solve the problem.
Oracle CLOB storage of strings greater than 4000 characters