Have you tried doing an "after" trigger, looking for 1 row?

----- Original Message -----
From: "Tyler Clendenin"

> Sorry for off topic but this is the only list i am on.
> 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 Clendenin
> GSL Solutions
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to