SQLException: ORA-01483: invalid length for DATE or NUMBER bind variable
garberxMay 8 2007 — edited May 9 2007I have a web application running on the TopLink version of 9.0.4.5 deployed on the WebSphere Application Server V5. Its session XML is set up as:
<should-bind-all-parameters>true</should-bind-all-parameters>
Underneath it, I use Oracle Client 10.1.x of JDBC and Oracle RAC of 10.1.x.
I have a database table composed of a BLOB field that is used by the application to store the PDF files. From time to time (sporadically), the application receives the following SQL exception:
Exception Description: java.sql.SQLException: ORA-01483: invalid length for DATE or NUMBER bind variable
for a given SQL insert statement. The confusing part of this puzzle is that the exact same SQL statement, which caused the above SQL exception, would work fine later without any error. In this case, no code change was made and just the application server was restarted.
Can anyone, especially those experts from the Oracle TopLink, help me understand the true cause(s) of this exception? Is this truly a problem about data binding? Is this an exception thrown by the Oracle Client or by the Oracle Server?
Many thanks for the help!