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.
posted 8 years ago
Please check the JavaRanch naming policy and adjust your display name to conform.