Register / Login
Win a copy of
Murach's Python Programming
this week in the
this forum made possible by our volunteer staff, including ...
Roel De Nijs
Stephan van Hulst
modifing data when Trigger fires
ravi v kumar
posted 9 years ago
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'".
rocket mass heater
Boost this thread!
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