aspose file tools*
The moose likes JDBC and the fly likes ORA-01704: String Literal Too Long Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "ORA-01704: String Literal Too Long" Watch "ORA-01704: String Literal Too Long" New topic
Author

ORA-01704: String Literal Too Long

Alok Sharan
Greenhorn

Joined: Oct 13, 2005
Posts: 5
Hi,

Because of some constraint I need to save the file content upto 5MB into database. My file upload functionality is working perfectly fine for data <= 4000 chars, but failing beyond that. The error it is reporting is ORA-01704. I googled the issue and found this as a problem with oracle itself. Can somebody suggest me the workaround to this? I am not sure how binding will work in this. I tried some binding concept but there again I found chars limit upto apprx 33000.

I am using CLOB as my column to keep the data.

I have to use Oracle 10g in my project.

currently I am using
java.sql.PreparedStatement.
setCharacterStream(int parameterIndex,
Reader reader,
int length);
method to save the file data into database.

Any suggestion/pointer will be apppriciable.

Thanks,
Al




Thanks,
Sharan
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 39436
    
  28
Please check the JavaRanch naming policy and adjust your display name to conform.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: ORA-01704: String Literal Too Long