Insert using %rowtype within a trigger
295482May 13 2003 — edited Jul 29 2003I have a trigger which on insert or update copies the current new row to an audit table in a different schema.
Until 9i release 2, using %rowtype to insert was not possible, but I cannot seem to get the new values to insert no matter what I try.
Has anyone any ideas how this can be achieved ?
I just want to insert the amended row into an identical table within another schema without having to reference each individual attribute on the table.
Any suggestions will be gratefully received.