Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

modifing data when Trigger fires

 
ravi v kumar
Ranch Hand
Posts: 56
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,

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'".
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic