Re: Help with Triggers

Giganews Newsgroups
Subject: Re: Help with Triggers
Posted by:  G Quesnel (dbaguy_o…@yahoo.com)
Date: 22 Aug 2006

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

Replies

In response to

Help with Triggers posted by Al Reid on Tue, 22 Aug 2006