[ATTACH=RIGHT]19013[/ATTACH]I will start off by saying that I don’t like to think of myself as lazy, instead I prefer to think that I am much too busy to take the time to complete the more mundane chores around the house like vacuuming and so on. Ok, I’m lazy and vacuuming is boring. Much like any tech-geek, if I see a high-tech way to do something, I tend to gravitate towards that, and when I saw the Neato XV-11 robotic vacuum I knew I had to try it. The XV-11 robotic vacuum cleaner is made by Neato Robotics of Silicon Valley. …

Member Avatar
Member Avatar
+3 forum 9

Hi I there a way to make a trigger completely independent from the calling table so that even if the trigger is made invalid, inserts can still be done to the table that calls the trigger? I created the following trigger: [CODE] CREATE OR REPLACE TRIGGER LOCAL.SYNC_TRIGGER AFTER INSERT ON LOCAL.LOCAL_TABLE FOR EACH ROW DECLARE PRAGMA AUTONOMOUS_TRANSACTION; ecode NUMBER; emesg VARCHAR2(200); BEGIN -- Code to setup data inserted into remote table omitted ... -- -- INSERT INTO REMOTE_TABLE@REMOTE_DB ( SEQ, COL1, COL2, ... ) VALUES ( REMOTE_TABLE_SEQ.NEXTVAL@REMOTE_DB, :new.col1, :new.col2, ... ); COMMIT; EXCEPTION WHEN OTHERS THEN ecode := SQLCODE; emesg …

Member Avatar
Member Avatar
+0 forum 3

The End.