Re: Simple Trigger
Posted by: Peter Brawley
Date: May 14, 2012 05:18PM
Looks like an ordinary debugging problem. You're the only one who has the tables, so you're the only one who can debug it. The easiest way to do that is to add stubs to your Trigger, for example create a debug table(info text) and to the Trigger add a line to each logical fork inserting msg.info describing the current values &c.
If you want us to debug the Trigger, you will have to post the results of SHOW CREATE TABLE for each table involved, and post enough INSERT statements to reproduce the problem you describe.
(Note: so I could read your code, I edited your post to add CODE tags to preserve indenting. Look up BBCode for how to do this for yourself.)
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.