This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes Oracle/OAS and the fly likes modifing data when Trigger fires Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "modifing data when Trigger fires" Watch "modifing data when Trigger fires" New topic
Author

modifing data when Trigger fires

ravi v kumar
Ranch Hand

Joined: Dec 14, 2004
Posts: 56
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'".
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: modifing data when Trigger fires