When trying to insert a 5000 character JSON string into an Oracle CLOB field, the following error message is shown:
ORA-01704 string literal too long
The insert is done with a JDBC step and a database procedure.
There is no error if the string is less than 4000 characters.
The CLOB column is supposed to be able to contain more than 4000 characters.
Release : 10.5.1
Component : CA Service Virtualization
Enter all parameters for the database procedure in the Parameter section of the step.
Not in the SQL Statement section.