Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help with Triggers

Re: Help with Triggers

From: G Quesnel <dbaguy_ott_at_yahoo.com>
Date: 22 Aug 2006 11:57:33 -0700
Message-ID: <1156273053.182920.245900@i3g2000cwc.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US