I want to replicate the values in another database
through trigger. when then traget database fail. suppose netwrok cable unplug and restart the traget machine, then statement hang up, can u specifie there time.
Here is my code below


CREATE OR REPLACE TRIGGER "REP_TEST" AFTER INSERT OR DELETE OR UPDATE OF EMPNO, ENAME ON TEST
REFERENCING NEW AS N OLD AS O FOR EACH ROW
BEGIN
IF INSERTING THEN
INSERT INTO TEST@MY_LINK(EMPNO,ENAME)
VALUES (:N.EMPNO,:N.ENAME);
ELSIF UPDATING THEN
UPDATE TEST@MY_LINK
SET EMPNO = :N.EMPNO,ENAME = :N.ENAME
WHERE EMPNO = :O.EMPNO;
ELSIF DELETING THEN
DELETE FROM TEST@MY_LINK
WHERE EMPNO = :O.EMPNO;
END IF;
END;

WHEN THE TARGET MACHINE FAIL THEN THE STATEMENT WILL FAIL.I WANT TO SPECIFIE TIME THERE. IF WITH IN SPECIFIED TIME TARGET MACHINE FIND THEN ITS OK OTHERWISE WILL SHOULD BE FAILED/

THANKS

sOHAIL