Hi all,

I have an instead of insert trigger on a view which is select * from <T1>. In the trigger we are inserting into T1 in addition to some inserts in other tables.This was working fine till yesterday. Now we are getting an ORA-00001 exception while inserting the records into the view. But the records are getting inserted into the table T1. The table has a composite primary key with one of the columns generated from the sequence. There were 29 inserts. We received the ORA-00001 error 29 times and 29 records were also inserted into the table. There was no jump in the sequence values.

StackTrace:java.sql.SQLException: ORA-00001: unique constraint (XXXXX.XPKPGM_PRT_PHYS_HST) violated
ORA-06512: at "XXXXX.PGM_PRT_PHYS_HST_VW_INS", line 127
ORA-04088: error during execution of trigger 'XXXXX.PGM_PRT_PHYS_HST_VW_INS_TR'

Please let me know how this could happen?

TIA

Vinodh
Confidentiality Statement:

This message is intended only for the individual or entity to which it is addressed. It may contain privileged, confidential information which is exempt from disclosure under applicable laws. If you are not the intended recipient, please note that you are strictly prohibited from disseminating or distributing this information (other than to the intended recipient) or copying this information. If you have received this communication in error, please notify us immediately by return email.


Oracle LazyDBA home page