A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Please help...triggers issue
Joined: Nov 12, 2008
Nov 25, 2008 23:16: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: Oct 23, 2005
Nov 26, 2008 00:13:00
Down Home Country Coding with Scott Selikoff
I agree. Here's the link:
- it saves me about five hours per week
subject: Please help...triggers issue
modifing data when Trigger fires
help required in writing row level trigger?
Please help..triggers issue
getting error while droping the user in oracle.
using :new in oracle JDBC Query
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013