Thanks for the response Can. But there is nothing wrong with the trigger. It
is working fine on the production database, and since the database I am
working on is an exact copy, the trigger is the same. However, it doesn't
fire even though it (look like) it is activated.
"Can" <no_at_spam.net> wrote in message
news:i3U%c.255619$vG5.246481_at_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 - 05:10:10 CDT
