sqlcode:1403 for insert records

dnat · Post by **dnat** » Wed Apr 08, 2009 12:17 am

Hi,

I am getting sqlcode:1403 while inserting the record into the table. Only one record gets rejected with this issue. I searched the forum, but couldnt find any resolution. Can anyone please help

i am using ORA OCI stage and upsert method, where for update i have mentioned the where clause as 1=2, so it wont go to update at all. This record shoud be inserted, but it is not inserting.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Apr 08, 2009 2:29 am

Do you have any insert trigger?

dnat · Post by **dnat** » Wed Apr 08, 2009 4:56 am

no, i dont think i have..but how to find that out?

chulett · Post by **chulett** » Wed Apr 08, 2009 8:13 am

Ask your DBA or if you have something like Toad (you should if you don't) it can show you. This is typically a PL/SQL error, hence the trigger question.

CLOPES · Post by **CLOPES** » Tue Jun 23, 2009 6:52 am

Hello,

got the same problem and it was an unique index that causes the trouble.
My keys were not the same as the Unique index.

HTH