Hi All,

I have a procedure [on DB-1], where in i am using DBLink to insert the data to a table on DB-2. and i have trigger on the same table of DB2.

Inserting the data from DB-1 to TABLE.DB-2 is working fine, but the trigger on TABLE.DB-2 is not getting executed immediately. The trigger is firing only when the 2nd record is inserted.

Even though the records exist, trigger is not happening.

Ex:
insert into DB-2.TABLE values ('A',1); -- On this insert trigger shul work.
insert into DB-2.TABLE values ('B',2); -- On this insert trigger shul work.

But the first trigger [A,1] is happening when B&2 are there, also B&2 will trigger on insert of C&3.

Has anyone faced the same issue, what is the fix for this.

Any help wud be highly appreciated.

Thanks,