Re: Trigger Question

Hi

Since you are using an Oracle trigger for that operation, the whole transaction is considered as one operation and the COMMIT will occur only when all the records are successfully inserted.

If your system experiences problems any errors while inserting records into T2 table, then your transaction in T1 will not be committed.

Therefore you can safely say, as long as you see a 'commit complete', the operation has successfully completed in T1 & T2.

Hope this helps

Arthur Merar wrote:

> Hello,
>
> 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.
>
> Now, they want this to be a one way communication only. We are not to
> query from then, only insert into their table.
>
> I need to know the result of the insert statement. If it is success
> or fails, I need to update a status field on my table (T1). However,
> I've been told that when a trigger fires off, the commit occurs AFTER
> the trigger is complete.
>
> If this is true, how will I know whether or not the commit was
> successful? Also, how will I ever find the record I just inserted?
>
> Can someone help?
>
> Thanks, please e-mail response.
>
> Arthur
> amerar_at_unsu.com

Received on Fri May 07 1999 - 02:30:45 CDT