A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Refactoring for Software Design Smells: Managing Technical Debt
this week in the
OO, Patterns, UML and Refactoring
modifing data when Trigger fires
ravi v kumar
Joined: Dec 14, 2004
Apr 14, 2008 06:41:00
Can we able to modify the data (:NEW) when the trigger fires?
when the trigger fires for insert or delete. i need to update data of that particular empid[example] date to set current_row indicate to Y
i am getting the following exceptions :
Delete Operation : " [DELETE - 0 row(s), 0.080 secs] [Error Code: 4092, SQL State: 42000] ORA-04092: cannot COMMIT in a trigger".
Insert Operation : "ORA-04091: table ALL.JOB is mutating, trigger/function may not see it
ORA-06512: at "ALL.TRIGGER1", line 15
ORA-04088: error during execution of trigger 'ALL.TRIGGER1'".
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: modifing data when Trigger fires
Error on trigger
ORA-01403: no data found + Oracle + Trigger
oracle setting up problem
ORA-21700: object does not exist or is marked for delete
Hibernate and Triggers
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015