Hi Friends,
I seek your immediate help.
My project is based on J2EE1.3 specification, it uses Oracle 9i as back end, The JDK version is 1.3 (local) and 1.4 (on application server)
We have a functionality that calls an oracle stored proc and passes a big xml
string into that. The destination data type defined in proc is CLOB and from front end we use
CallableStatement.setAsciiStream(1,ByteArrayInputStream,length) to set the value.
Recently, we enhanced the functionality and The length of the input xml string gets increased (crosses 32K) in some scenario.
When the length is greater than 32K, we are getting following exception:
java.sql.SQLException: Data size bigger than max size for this type
For all other instances when the length is less than 32K, The functionality works fine without an issue.
we use Oracle thin driver version 9.0.2.0.
Please let us know your thoughts asap. Your suggestion/advise would be a great help to me.
Thanks & Regards
Abhishek Khandelwal