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 Issue : Replicate Insert

SylarSep 9 2005 — edited Sep 9 2005
Hi,

I´m a newbie programing with Pl/SQL and I have a doubt I couldn´t find in the manuals.

I´m making a code to replicate the data i insert in another database via dblink :

CREATE OR REPLACE TRIGGER my_test
AFTER INSERT
ON TESTE01.DBLINK
BEGIN
INSERT INTO DBLINK@dblinktest VALUES (1);
END;

so everything I insert in my database it inserts "1" in the other. How can I get the same value I inserted in my database and insert it in the other via dblink ?

Another issue. If the dblink crashed my insert fails. is there any way to insert it into my database and fail for the dblink database ?

Thanks in advance,
Felipe
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 7 2005
Added on Sep 9 2005
7 comments
659 views