djberg96 (2603)

More on insert triggers

For reasons that I cannot determine, the insert triggers no longer work. Oh, they compile fine, they LOOK like they should work but they just....don't. I get errors along the lines of, "attempting to insert a null value...", even though that's what the triggers are supposed to handle.

If I have to manually call sequence.nextval and insert it on my own, there's not much point to having the triggers. Besides, it'll improve performance.

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
Without JavaScript enabled, you might want to
use the classic discussion system instead. If you login, you can remember this preference.

Please Log In to Continue

I may be asking the obvious, but have you dropped and then recompiled ? On some heavily used/replicated/just plain weird databases, I've found that Oracle will assure you that the triggers/stored procedures/packages have compiled correctly when they haven't. I am sure there is a scientific reason for all this, but my cargo-cult means of dealing with it is embedding a couple of unmissable logging statements (in an autonomous transaction) and if that doesn't register on the log, just drop/recompile. In genera