Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Mutating trigger, using Oracle 8.1.7

Re: Mutating trigger, using Oracle 8.1.7

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Wed, 24 May 2006 15:25:25 GMT
Message-ID: <FV_cg.84011$H71.82819@newssvr13.news.prodigy.com> 





Peter.Williamsson_at_gmail.com wrote:


> Hi and thank's for your response!

> I've tested it on an Oracle 9.2.0.5.0 server as well but unfortenately

> with the same result...

> /Peter




Did you try with PRAGMA AUTONOMOUS_TRANSACTION? Create a procedure,
mark it with the pragma and invoke it from the trigger. There are
caveats, however. I have to repeat the previous advice: look for the
description on asktom.


-- 
Mladen Gogala
http://www.mgogala.com


Received on Wed May 24 2006 - 10:25:25 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US