Fatal error while using Oracle connector for deletes.

Pravenai · Post by **Pravenai** » Tue Dec 18, 2012 3:06 am

Hi,

I am getting the following error while using Oracle connector stage:
Error code: 24,381, Error message: ORA-24381: error(s) in array DML.

I get this error only when there is a rejection or a warning. I am deleting the data from the target table.
I am using the default parameter values for Array size. (I tried changing the values still getting the error).

Thanks for your help.

Regards,
PR

ray.wurlod · Post by **ray.wurlod** » Tue Dec 18, 2012 1:14 pm

Try using Array Size 1 for DELETE.

Pravenai · Post by **Pravenai** » Thu Dec 20, 2012 2:07 am

Checked with array size set to 1 but still getting the same fatal error.

Regards,
PR

ray.wurlod · Post by **ray.wurlod** » Thu Dec 20, 2012 4:17 am

Was the commit size also set to 1?

Pravenai · Post by **Pravenai** » Thu Dec 20, 2012 4:50 am

Yes.

Isolation level option under transaction is set to Read committed.
Record count option under transaction is set to 1.
Array size option under session is also set to 1.

Still getting the same fatal error.

Regards,
PR

chulett · Post by **chulett** » Thu Dec 20, 2012 8:18 am

Are you current on your fixpacks? Have you opened a case with your official support provider yet?

Pravenai · Post by **Pravenai** » Thu Dec 20, 2012 10:27 am

I havent. But is this error related to fixpacks or am I missing any options?

Regards,
PR

ray.wurlod · Post by **ray.wurlod** » Thu Dec 20, 2012 4:10 pm

I don't think you're missing any options. Array and commit size need to be 1 for DELETE. You have these.

Pravenai · Post by **Pravenai** » Fri Dec 21, 2012 1:11 am

Thanks.

I will open a case with the support provider to install the fixpacks.

Regards,
PR