Triggers and Archiving

Hi there,

From a delete trigger, I'm trying to insert the row being deleted from a production table into an archive table before the delete takes place. I want to stay away from listing each individual column name in the insert statement in the event the table is modified/recreated. Is there a way to reference the whole row so I can insert it into the archive table?

I've tried using dynamic sql to create and parse a command with the :old column names, but it thinks the :old.% columns are bind variables and returns an error.

Any suggestions? Received on Thu Jan 22 1998 - 00:00:00 CET