Path: text.usenetserver.com!out03a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!cycny01.gnilink.net!cyclone1.gnilink.net!gnilink.net!nx02.iad01.newshosting.com!newshosting.com!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!feeder.news-service.com!feeder.news-service.com!border1.nntp.ams.giganews.com!nntp.giganews.com!newsfeed.xs4all.nl!newsfeed3.news.xs4all.nl!xs4all!textnews.nntp.hccnet.nl!textreader.nntp.hccnet.nl!not-for-mail From: sybrandb@hccnet.nl Newsgroups: comp.databases.oracle.server Subject: Re: Trigger Question with Commit Date: Fri, 08 Aug 2008 23:48:42 +0200 Message-ID: References: <5cace5b2-389f-4630-aa48-e712de04839f@x35g2000hsb.googlegroups.com> X-Newsreader: Forte Agent 4.2/32.1118 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 27 Organization: Hobby Computer Club News Network NNTP-Posting-Date: 08 Aug 2008 21:48:18 GMT NNTP-Posting-Host: 80.127.252.24 X-Trace: 1218232098 textreader.nntp.hccnet.nl 743 sybrandb/80.127.252.24:1835 X-Complaints-To: abuse@hccnet.nl Bytes: 1795 Xref: usenetserver.com comp.databases.oracle.server:447062 X-Received-Date: Fri, 08 Aug 2008 17:48:19 EDT (text.usenetserver.com) On Fri, 8 Aug 2008 14:40:45 -0700 (PDT), artmerar@yahoo.com wrote: > >Hi, > >I know that you cannot commit inside a trigger. But, the trigger I >have calls a procedure. That procedure inserts into another table and >issues a commit. > >Problem is that the procedure is not only called from the trigger, but >other procedures. So, sometimes a commit is needed. > >Can I use AUTONOMOUS_TRANSACTION for the call which is initiated from >the trigger? A transaction is a series of dml statements which *logically* belong together. Surely you can use an AUTONOMOUNS_TRANSACTION if you are not interested in database consistency. However, committing in a procedure is always a bad, bad idea, and has always been discouraged by Oracle. However, if your ambition is to set up a disaster application, no one will stop you. -- Sybrand Bakker Senior Oracle DBA