RE: Trigger Question - Thanks for all the help

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: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com]On
:->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"
:-><ncullen_at_catlogic.com>
:->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: gkatteri_at_fastmail.fm
:->
:->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: ListGuru_at_fatcity.com (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: ncullen_at_catlogic.com

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: ListGuru_at_fatcity.com (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).