Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Trigger Question

Re: Trigger Question

From: Dante <dnotari_at_my-dejanews.com>
Date: Fri, 07 May 1999 10:10:40 GMT
Message-ID: <7gue6u$rt8$1@nnrp1.deja.com>


Arthur,
  ... or you could try to use snapshots

  Which is a DB feature which does what you    are trying to accomplish.

Regards
Dante
In article <3732202e.265825_at_news.chaven.com>,   amerar_at_unsu.com (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
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri May 07 1999 - 05:10:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US