Hi All,
I need to create a trigger who insert rows ,using an oracle DBlink ,on a second table. The code is:
CREATE or REPLACE TRIGGERÂ TRIGGER_EXAMPLE
AFTER INSERT ON T_AG FOR EACH ROW
BEGIN
INSERT INTO t_ag_hab@DBLINK_DEV
values
(new:id_order,
new:date_order
new:delivery_date
);
END;
It's my first time that I use Dblink. My question is: after the insert on T_AG, commit command work and committed the rows also on table t_ag_hab@DBLINK_DEV?
The t_ag_hab is on another Oracle DB, and both system have Oracle 11 version.
Thanks in advance.