Error when trying to update a record on table with a trigger

From: Arthur Carré (arthurcarre_at_glcp_dot_qc_dot_ca)
Date: 04/22/04 

Date: Thu, 22 Apr 2004 14:12:59 -0400

When i try to do an update on a record on a table that have a trigger, i got
the following error:

'Row cannot be located for updating. Some values may have been changed since
it was last read.'

If i remove the trigger, the update is alright. Moreover, even if i get
this error message, the update is successful.

My trigger is only updating another table with the same changes done in the
updated table.

Is there something am doing wrong ???

Thanks, Arthur
arthurcarre_at_glcp_dot_qc_dot_ca

Relevant Pages

  • Re: Create a Trigger for an existing View
    ... If user X with the USER_ID 2 will complete a new order my trigger must ... updating trigger, but the actuator for the trigger is an "insert into" ... is just a stored query, it doesn't immediately materialize and store ... I must insert the new entry of DEMO_ORDERS over a trigger into my new ...
    (comp.databases.oracle.server)
  • Re: SQL Update question
    ... replication going on in the ... may trigger unnecessary replication of the data and potentially cause ... updating a field unnecessarily may cause the trigger to fire. ...
    (microsoft.public.vb.general.discussion)
  • Re: Create a Trigger for an existing View
    ... INNER JOIN DEMO_ORDERS ... If user X with the USER_ID 2 will complete a new order my trigger must ... updating trigger, but the actuator for the trigger is an "insert into" ... I must insert the new entry of DEMO_ORDERS over a trigger into my new ...
    (comp.databases.oracle.server)
  • Re: Create a Trigger for an existing View
    ... On 10 Apr., 06:45, "Vladimir M. Zakharychev" ... INNER JOIN DEMO_ORDERS ... If user X with the USER_ID 2 will complete a new order my trigger must ... updating trigger, but the actuator for the trigger is an "insert into" ...
    (comp.databases.oracle.server)
  • Re: Trigger for updated rows when PK changed
    ... I guess in pure relational theory updating a pk is meaningless - it's always ... Presumably a row-level trigger in something like Oracle would reflect this ... John ... > other than the primary key to uniquely the rows of your table, ...
    (microsoft.public.sqlserver.programming)