Re: Logging trigger activity and RAISE error
Odd. If you add ...
SELECT Row_Count() INTO @insertN;
after the INSERT INTO trigger_log cmd, @insertN gets set to 1, yet no row gets added to trigger_log unless you comment out the SIGNAL call. Consider reporting this as a bug.
PB
Subject
Views
Written By
Posted
8185
October 18, 2011 09:26AM
Re: Logging trigger activity and RAISE error
2575
October 18, 2011 01:23PM
2310
October 19, 2011 11:57AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.