|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
How about replacing your select statement with something like ...
Select CCAPADM.SEQ_PRINT_INDEX.NEXTVAL INTO :NEW.PRINT_INDEX from dual;
Help with Triggers posted by Al Reid on Tue, 22 Aug 2006