Could anyone give me some insight on what is the best way to implement auditing in an Oracle database? The problem is that physical data deleted, inserted or updated has to be stored and has to be associated with the appllication user (not Oracle user), date and type of action committed.
What is better — to use triggers or stored procedures? I would be very grateful if anyone suggests some approaches.
