Re: Trigger Question

From: Gustavo Tavares <grst_at_zaz.com.br>
Date: Thu, 6 May 1999 23:28:05 -0300
Message-ID: <7gtj7e$a12$2@srv4-poa.nutecnet.com.br>

Arthur Merar wrote in message <3732202e.265825_at_news.chaven.com>...
>Hello,

Hello Arthur

>Are you good at Triggers? Here is my situation:
>
>I have two tables (T1 & T2) in a distributed network environment.
>When a record is inserted into T1, then a trigger will fire off and
>insert that same record into T2, which is located on a different
>server belonging to a different department...

In this situation, i would grant insert only access on the T2 table and use the structure of PL/SQL (procedural blocks) to manage the errors reported from the remote database.

if you have a block like this on your trigger, you commit statment wil be fired just if you insert statment finished with success. Otherwise the roolback statment will be fired.

// ---------------------------

BEGIN
  INSERT ON T2....;
  COMMIT;
EXCEPTION
  ROLLBACK;
END

// ---------------------------

--
[]´s

from Goiania - Goias - Brasil
Gustavo Roberto Silva Tavares

to Contact me --------------------------------------------------------------------- | Web : <www.geocities.com/Area51/Corridor/2078> | Personal e-mail : <grst_at_zaz.com.br> | Business e-mail : <gtavares_at_voga.com.br> | ICQ : 11024838

Ask for my *new* PGP Public Key !

Received on Thu May 06 1999 - 21:28:05 CDT