This content has been marked as final. Show 3 replies
Is this behavior consistent or intermittent?
If intermitten, and your db is 9206, you're likely encountering the following rdbms bug:
Bug.4015165 (74) REGRN SCALAR VARCHAR2 IN BINDS WITH DIFFERENT SIZE RANDOMLY FAILS WITH ORA-06502
and should be resolved by patching your database.
I'm not sure why, but ODP seems to encounter this bug a lot more than other drivers.
If not intermittent, or if you are using a current patch level of database, a complete testcase would probably be best.
Where can i find the patch?
The 9208 RDBMS patch is on Metalink, as patch number 4547809.