Steve,
> At the moment, I can't seem to pass the NEW values into trace_actions.
> Similarly, as trace_actions is a common process, I have no way of
> knowing whether NEW contains 'sourceDetRecNo' or 'sourceDetProdRecNo'
> (unless I case the table name)
You don't pass NEW and OLD as parameters. They are automatically available
inside the trigger procedure.
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco