Trigger Issue : Replicate Insert
SylarSep 9 2005 — edited Sep 9 2005Hi,
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