A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Spring in Action
this week in the
Object Relational Mapping
Please help..triggers issue
Joined: Nov 12, 2008
Nov 25, 2008 23:15:00
I have a requirement of a trigger which will trim the value of column CAA_NAME as soon as this column is updated.
I hv written the foll trigger to achieve the same.
But after the trigger is configured and i try to update caa_name column, I'm getting -
ora-04091: table caa_ca is mutating,trigger-function may not see it
ora-06512: at "TRIMCAACC4_MAIN", line 2
ora-04088: error during execution of trigger
CREATE OR REPLACE TRIGGER TRIMCAACC4_MAIN
AFTER UPDATE OF
REFERENCING NEW AS NEW
FOR EACH ROW
UPDATE CAA_CA SET
CAA_NAME = TRIM(:NEW.CAA_NAME)
WHERE CAA_CA_ID=:NEW.CAA_CA_ID ;
Joined: Jul 20, 2005
Nov 25, 2008 23:30:00
Please do not post the same question in multiple forums. Let's continue this discussion in your other thread at
Don't get me started about those stupid
subject: Please help..triggers issue
modifing data when Trigger fires
Please help...triggers issue
using :new in oracle JDBC Query
help required in writing row level trigger?
getting error while droping the user in oracle.
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014