what's the root cause to "ORA-24816"

nalin · **Posted:** Wed Jul 30, 2008 3:00 am

Hi all,
we have implented two "CLOB" fields in one table since we want to store more details.
But when we try to insert, update table. following error was occurred.In the hbm we have
mapped those fields like this.
<property name="model-attrbute" not-null="false" type="java.lang.String">
<column name="COLUMN_NAME" length="2000"/>
</property>
we assume that hibernate can handled string to CLOB.
Since we are not getting error always; we came to confirm that hibernate handle this.
But sometimes when we try to insert, update data. following error was occurred (Note we increased the details to insert ).

[Unable to update <table name> record - Hibernate operation: Could not execute JDBC batch update; uncategorized SQLException for SQL [insert into <table name>

At the last, this oracle specific error was displayed.
SQL state [99999]; error code [24816]; ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column
; nested exception is java.sql.SQLException.

versions we are using

the solution is given in the forums are work around solutions such as http://forum.hibernate.org/viewtopic.php?t=969929&highlight=ora24816

using that we can come to solutions.
But what i want to know is why this type of error comes.
what are the possible configuration can be root cause to this error. such as
oracle driver either thin or OCI
hibernate version
or else another reason
what is the best possible way to resolve this.

thanks in advance
Nalin