something so simple. Thank you for your help.
Tyler Clendenin
GSL Solutions
_____
From: Janet Schmitt [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 08, 2004 3:06 PM
To: CF-Talk
Subject: Re: Oracle Mutating Table
> > I am having a problem with oracle's mutating table error. All I want to
>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/adg1
3trg.htm#786
Janet.
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
