Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!colt.net!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed1.e.nsc.no!news2.e.nsc.no.POSTED!53ab2750!not-for-mail From: "Richard Gjerde" Newsgroups: comp.databases.oracle.misc Subject: enabled trigger doesn't fire Lines: 12 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Message-ID: NNTP-Posting-Host: 194.248.208.82 X-Complaints-To: news-abuse@telenor.net NNTP-Posting-Date: Thu, 09 Sep 2004 09:50:14 MEST X-Trace: news2.ulv.nextra.no 1094716214 194.248.208.82 Date: Thu, 9 Sep 2004 09:54:05 +0200 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:112528 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, even though the trigger as far as I can see is enabled. (I am examining it in Oracle DBA Studio.) I guess the trigger cannot be enabled even if it looks as it is because then the fact that nothing gets inserted in the second table shoul lead to a rollback of insert in the first table? So why is it that it still looks as if it is enabled and how can I make it truely enabled. (I have tried enabling it with sql.) The database is a copy of a production base and there the trigger works which makes me even more confused.