problem inserting 32k longvarchar data via JDBC
843859Oct 26 2005 — edited Nov 3 2005Hello,
I have a Java Application that reads data from a XML file and inserts them into an Oracle 9i table, which has, among others, a LONG type field.
In some point of the application, I need to insert some text into the LONG field using CallableStatement.setAsciiStream. But, when I try to "CallableStatment.execute", if the data I've inserted are bigger than 32700 bytes, the application raises an SQLException with the Oracle error "ORA-01460: unimplemented or unreasonable conversion requested". When I call the setAsciiStream, it works fine, but when I execute the CallableStatement, the exception raises.
I've tried to "force" the setAsciiStream length to be limited to, say, 32000 bytes in order to test, and, with this limit, the application works fine, but truncates the text I want to insert into the LONG field.
It seems that I cannot execute a SQL Statement containing more than 32k, i.e. the length of my whole sentence can't exceed 32k...
Does anybody knows anything about that? Is there a way to work around this problem?
Thank you very much
Caio