This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Please help...triggers issue Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Please help...triggers issue" Watch "Please help...triggers issue" New topic
Author

Please help...triggers issue

Aman Gupta
Greenhorn

Joined: Nov 12, 2008
Posts: 10
Hi,
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


Please Help.



CREATE OR REPLACE TRIGGER TRIMCAACC4_MAIN
AFTER UPDATE OF
CAA_NAME
ON
CAA_CA
REFERENCING NEW AS NEW
FOR EACH ROW
BEGIN
UPDATE CAA_CA SET
CAA_NAME = TRIM(:NEW.CAA_NAME)
WHERE CAA_CA_ID=:NEW.CAA_CA_ID ;

END;
Scott Selikoff
author
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3740
    
  10

Read this: http://asktom.oracle.com/tkyte/Mutate/


[OCA 8 Book] [Blog]
 
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: Please help...triggers issue
 
It's not a secret anymore!