AFTER UPDATE TRIGGER doesn't has correct value (SOLVED)
hi,
I have table T_MEDIA (with field MED_DURATION) that has an AFTER UPDATE trigger.
This causes a TRIGGER by itself in another table (T_ATTRIBUTE_VALUE) in case MED_DURATION value has changed. , now this T_ATTRIBUTE_VALUE trigger does a select on T_MEDIA but it seems that MED_DURATION has still the old value and not yet the new value of MED_DURATION, I thought AFTER UPDATE is called after the table has been updated..
or am I wrong?
regards
marc
Edited 1 time(s). Last edit at 06/25/2006 03:27PM by Marc Van Olmen.
Subject
Views
Written By
Posted
AFTER UPDATE TRIGGER doesn't has correct value (SOLVED)
4711
June 25, 2006 03:22PM
2518
June 25, 2006 03:27PM
1995
June 25, 2006 03:29PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.