2 questions - delete and old?
Hi,
Ive been playing around with triggers in order to provide an audit trail for one of our apps. Ive 2 problems though :-
1) When data is inserted or updated I can use new.field to get new value the value. If a field is to be updated or deleted how do I get at the old/original value? (old.field? Didnt seem to work....)
2) Possibly related to my ignorance of the above my before delete trigger seems to hang - is there anything special I should know about deletion and triggers?
Any help appreciated
Lee
Subject
Views
Written By
Posted
2 questions - delete and old?
3373
July 25, 2005 09:04AM
2306
July 25, 2005 09:35AM
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.