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: Using insert statements in triggers and functions

Re: Using insert statements in triggers and functions

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 13 Jul 2005 06:58:54 -0700
Message-ID: <1121263134.585654.306470@g47g2000cwa.googlegroups.com> 





Paulos, the key words in AK's post are "PRAGMA AUTONOMOUS_TRANSACTION"
which means this event happens independent of the calling transaction
so this commit does not affect the caller's transaction.



HTH -- Mark D Powell --
Received on Wed Jul 13 2005 - 08:58:54 CDT












Original text of this message













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