See in-line replies..... Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI "Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is." --Unknown
-----Original Message----- Nuala Cullen Sent: Thursday, January 08, 2004 2:24 PM To: Multiple recipients of list ORACLE-L Hi All, Firstly my apologies if this seems like a very *stupid* question but I'm a tad confused (and it's late in the evening) When an AFTER INSERT trigger is fired (row level) has the row been committed to the database at this stage? <M.Bobak> No, this action happens after the insert but before the completion of the INSERT statement. In other words, the trigger actions are atomic to the statement that caused them to be executed. If the INSERT is committed, the trigger changes are also committed. If the INSERT is rolled back, so are the trigger modifications. If so is it ok to call a package in the trigger that selects that row and changes some values in the row? <M.Bobak> No, this would likely cause mutation when doing multi-row inserts. If this is necessary, you may want to re-consider your app design. If that's out of the question, check MetaLink for the standard mutation solution. <M.Bobak>Hope that helps! <M.Bobak>PS Autonomous transactions are different, and an exception to the above. See the documentation for more details.... Thanks, N. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bobak, Mark INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
