A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
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
[OCA 8 Book]
It is sorta covered in the
JavaRanch Style Guide
subject: Please help...triggers issue
modifing data when Trigger fires
using :new in oracle JDBC Query
help required in writing row level trigger?
Please help..triggers issue
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-2015