Re: Help with Triggers

G Quesnel wrote:
> You seemed to be trying to update a row in the middle of updating that
> row ... it looks ugly.
> Regardless of the validity of what you are trying to achieve,
> you should remove the update statement from withing your trigger (and
> the commit).
>
> How about replacing your select statement with something like ...
> Select CCAPADM.SEQ_PRINT_INDEX.NEXTVAL INTO :NEW.PRINT_INDEX from dual;
>
> hth

Also, the 10gR2 documentation indicates that :

Restrictions on AFTER Triggers AFTER triggers are subject to the following restrictions:

      You cannot write either the :OLD or the :NEW value.

So you should change the trigger to a BEFORE trigger.

FM Received on Tue Aug 22 2006 - 14:05:19 CDT