File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Java SE 8 for the Really Impatient
this week in the
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
subject: Please help...triggers issue
using :new in oracle JDBC Query
help required in writing row level trigger?
Please help..triggers issue
modifing data when Trigger fires
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