• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

ORA-01704: String Literal Too Long

 
Alok Sharan
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Campbell Ritchie
Sheriff
Posts: 51332
86
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please check the JavaRanch naming policy and adjust your display name to conform.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic