Generate undo information

We want to generate "undo information" for DML-Statements by our own and store the data somewhere (e.g. in a table).

Background: During a software deployment we have to insert/update records in the database. The requirement is, that an undo of the software deployment can happen in a later stage (database changes already commited). Therefore all information to undo database changes have to be stored. These information should be generated, not coded by a developer. Is there anything that gives me the corresponding undo statement for a DML?

How can we do this, any advises?

Thanks in advance, Nick Received on Mon Mar 17 2003 - 07:46:12 CST