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
The Java EE 7 Tutorial Volume 1 or Volume 2
this week in the
jQuery UI in Action
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
Don't get me started about those stupid
subject: Please help...triggers issue
using :new in oracle JDBC Query
modifing data when Trigger fires
help required in writing row level trigger?
getting error while droping the user in oracle.
Please help..triggers issue
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014