Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Trigger Question
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: mladen_at_wangtrading.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).Received on Thu Jan 08 2004 - 13:44:34 CST