Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!feed.news.tiscali.de!newsfeed01.chello.at!newsfeed02.chello.at!news.chello.at.POSTED!53ab2750!not-for-mail From: "Can" Newsgroups: comp.databases.oracle.misc References: Subject: Re: enabled trigger doesn't fire Lines: 19 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Message-ID: Date: Thu, 09 Sep 2004 07:59:10 GMT NNTP-Posting-Host: 80.110.189.168 X-Complaints-To: abuse@news.chello.at X-Trace: news.chello.at 1094716750 80.110.189.168 (Thu, 09 Sep 2004 09:59:10 MEST) NNTP-Posting-Date: Thu, 09 Sep 2004 09:59:10 MEST Organization: Customers chello Austria Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:112530 "Richard Gjerde" schrieb im Newsbeitrag news:WWT%c.8576$g%5.89507@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