Re: enabled trigger doesn't fire

From: Can <no_at_spam.net>
Date: Thu, 09 Sep 2004 07:59:10 GMT
Message-ID: <i3U%c.255619$vG5.246481@news.chello.at>

"Richard Gjerde" <richard_gjerde_at_yahoo.no> schrieb im Newsbeitrag news:WWT%c.8576$g%5.89507_at_news2.e.nsc.no...
> I am doing some software testing on a database. As part of the testing I
am
> inserting data into a table which has a trigger which is supposed to
insert
> data into another table on insert. This does not happen

Hi Richard,

Maybe you have a "commit" statement in your trigger? Commit statements are not allowed unless you declare the trigger to be autonomous. Or your trigger throws another exception? I'd look out for the exceptions possibly occuring before the insert...

Can Oezdemir Received on Thu Sep 09 2004 - 02:59:10 CDT