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

[volcano]

Hi, I have jave program that will parse a XML (I make use of SAX parser) and retrieve the content of some elements to store into the DB. However sometimes I found I got an error known as "java.sql.SQLException: ORA-01704: string literal too long". I have made the relative field in the table to be of datatype LONG. But it seems it doesn't help. Do you have any idea?

Thanks

 

[nationavon]

The Oracle error you are getting means that you have exceeded the length of the column. I wouldn't recommend using longs since they have been deprecated. I typically use a Varchar2 which can hold up to 4000 characters. If I have data that is more than 4000 like 5000 for instance. I will place 4000 in one row and 1000 in another. If this method doesn't work for you I would suggest using Clob's. Using Clob's has the drawback of not being able to be searched easiler.

Nathan