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).