>do
> > is, ON BEFORE UPDATE, Check the number of rows in the table being updated.
> > If the number of rows is 0 set the :New.DateZero to the sysdate. Does
> > anyone know a simple way around this?
Tyler -
The FOR EACH ROW in your trigger is causing the problem. You need to write
the row count to a temporary table or a package variable and then use an
AFTER statement trigger. The following Oracle documentation gives more
details about how to fix this problem:
http://download-west.oracle.com/docs/cd/A87860_01/doc/appdev.817/a76939/adg13trg.htm#786
Janet.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
