Problem with array insert and CLOB
429515Jan 20 2010 — edited Feb 12 2010Hi,
I have run into a problem when doing array insert to a table with a CLOB column.
When inserting 9000 rows, the ExecuteNonQuery call just hangs "forever".
The amount of data is small, about 200 bytes/row, (20 bytes in CLOB column)
Splitting into smaller chunks (arrays) of 100 rows, makes it work.
Also changing the type of the column from CLOB to VARCHAR2 makes it work.
I am using ODP.NET 11.1.0.7.20 connecting to a database version 9.2.
Is this a known problem? If not, I can try to reproduce the error in a small test program.
Thanks,
Nils