IIS-CONN-ORA-001003, ORA-24381

mrbalajidev · Post by **mrbalajidev** » Thu Jun 17, 2010 12:28 pm

I am trying to load a table using oracle connector stage. The job loads nearly a million records. But i face the below issue

IIS-CONN-ORA-001003] The OCI function OCIStmtExecute returned status -1. Error code: 24,381, Error message: ORA-24381: error(s) in array DML. (CC_OraStatement::executeInsert, file CC_OraStatement.cpp, line 1,243)

Can some one please help me?.. I checked in oracle for ORA-24381 error which says the DML array cannot handle more that 2^16 records but i used to load more rows than this.

chulett · Post by **chulett** » Thu Jun 17, 2010 3:45 pm

This isn't about a limit on the number of records you can load, but how many you can bind into a single array. Let's start with how exactly you are 'loading' this data, can you provide the options you are using in the connector? What array size are you using?