-
Need Help in Trigger Timing.
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|