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
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
rocket mass heater
subject: Please help..triggers issue
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.
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014