Hi All, Thanks for all the tips and links to web sites. Really appreciated.
I did have a mutating trigger - but I also had it calling a pre-existing procedure that had a commit in it (which from what I read today is not allowed) In the end I put the code in an existing procedure - it took only about 5 lines or so which was similar to implement than the mutating trigger solution. Regards, N. :->-----Original Message----- :->From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] :->Behalf Of :->GovindanK :->Sent: 08 January 2004 21:20 :->To: Multiple recipients of list ORACLE-L :->Subject: Re: Trigger Question :-> :-> :->Ok. Here you go. :-> :->http://osi.oracle.com/~tkyte/Mutate/index.html :-> :->Let me know if you find this useful. :-> :->HTH :-> :->GovindanK :->OCP 8,8i :->Brainbench Certified Master DBA(8) :-> :-> :->On Thu, 08 Jan 2004 11:24:25 -0800, "Nuala Cullen" :-><[EMAIL PROTECTED]> :->said: :->> :->> 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. :->> :-> :->-- :->http://www.fastmail.fm - Or how I learned to stop worrying and :-> love email again :->-- :->Please see the official ORACLE-L FAQ: http://www.orafaq.net :->-- :->Author: GovindanK :-> 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: Nuala Cullen 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).