I have a column in database with datatype = long. In my insert statement, one of the text literal has more than 4400 characters. It gives me this error message:

java.sql.SQLException: ORA-01704: string literal too long


How do I solve this problem?

Will it help if I concate my text literl using

'a'||'b'||'c'


where 'a', 'b', 'c' are text literals of length less than 4000.