Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Mutation on an after update row trigger :? - a work around would be helpful :
Sorry for the stupid answer. I didn't read properly the Title.
On Thu, 02 Aug 2001 17:00:21 GMT, e9926043_at_student.tuwien.ac.at (Sebastian Scholz) wrote:
>I think your problem is that you're using a BEFORE Trigger, however,
>in your Case you need an AFTER Trigger.
>
>Sebastian
>
>
>On Thu, 2 Aug 2001 17:48:47 +0100, "CME" <support_at_cmesys.demon.co.uk>
>wrote:
>
>>Dear all,
>>
>>
>>I have a trigger that basically updates one field within the record with the
>>current date, so we are able to see when the row was last updated. This code
>>has worked fine in VB against a Sybase database.
>>
>>
>>Now however I am getting a mutation. I have read around the subject and it
>>states that I am trying to do two updates on the row :)...which is correct.
>>
>>
>>
>>Bascially I want the LastUpdated field to be updated whenever that row is
>>updated.
>>
>>
>>Any help would be gratefully received.
>>
>>
>>Thanks
>>
>>
>>Matt.
>>
>>
>
Received on Thu Aug 02 2001 - 13:32:40 CDT