ORA-01704: string literal too long

Error:

Receiving ORA-01704: string literal too long errors
in the KernelApplication.log file. We receive sting files from our
customers and some can be very large. So obviously this information is
not making it into the Oracle log database.

 

2013-12-13 15:30:44 ','JmsSource','Running','localhost','')
2013-12-13 15:30:44 java.sql.SQLException: ORA-01704: string literal too
long

 

Cause:

If the logging level is set to debug, then the entire JMS message may be inserted into the log database leading to this issue. The error is occurring when attempting to insert into the AU_MSG column of the AU_TRANSACTIONLOG table of the log database. The size of this column is 4000 characters.

 

Solution:

1) Change the process flow logging level to ERROR

2) During your debugging phase reduce the size of the incoming files to sample/examples

Have more questions? Submit a request

0 Comments

Article is closed for comments.