Re: Help with Triggers

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 Received on Tue Aug 22 2006 - 13:57:33 CDT