You can do some funky stuff with Autonomous Transactions (trigger independent from initiating transaction), but I need lots more coffee before even attempting more detail on this.
Henry -----Original Message----- Mladen Gogala Sent: Thursday, January 08, 2004 2:45 PM To: Multiple recipients of list ORACLE-L Row has not been commited yet. The AFTER INSER trigger fires after the row has been inserted. Rollback can still undo all the changes performed by both insert and trigger. And no, trigger cannot select from the table it is defined on, not even through a procedure. On 01/08/2004 02:24:25 PM, Nuala Cullen wrote: > > 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? > > If so is it ok to call a package in the trigger that selects that row and > changes some values in the row? > > Thanks, > > N. > > -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Poras, Henry R. 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).
