Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Trigger and DBlink

user4421692Jan 30 2017 — edited Jan 30 2017

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.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 27 2017
Added on Jan 30 2017
2 comments
846 views