File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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 and Relational Databases
Bookmark "ORA-01704: String Literal Too Long" Watch "ORA-01704: String Literal Too Long" New topic

ORA-01704: String Literal Too Long

Alok Sharan

Joined: Oct 13, 2005
Posts: 5

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
setCharacterStream(int parameterIndex,
Reader reader,
int length);
method to save the file data into database.

Any suggestion/pointer will be apppriciable.


Campbell Ritchie

Joined: Oct 13, 2005
Posts: 46375
Please check the JavaRanch naming policy and adjust your display name to conform.
I agree. Here's the link:
subject: ORA-01704: String Literal Too Long
It's not a secret anymore!