Insert using DBLink; Trigger is not executing
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.
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.