tag:blogger.com,1999:blog-20612393.post2634930602128844848..comments2023-09-29T21:26:11.876+07:00Comments on Surachart Opun's Blog: PRAGMA => ORA-00060: deadlockSurachart Opunhttp://www.blogger.com/profile/05646896104906516714noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-20612393.post-30101923619519101102008-11-29T02:47:00.000+07:002008-11-29T02:47:00.000+07:00AUTONOMOUS TRANSACTION + ORA-00060: deadlock error...AUTONOMOUS TRANSACTION + ORA-00060: deadlock error<BR/><BR/>I think this cause developer you should check and try to commit/rollback often.<BR/><BR/>we can protect this problem with wrong architecture program.<BR/><BR/><BR/>good luck.Surachart Opunhttps://www.blogger.com/profile/05646896104906516714noreply@blogger.comtag:blogger.com,1999:blog-20612393.post-52179049649311628252008-11-28T23:47:00.000+07:002008-11-28T23:47:00.000+07:00Hi dear.I have a problem in a situation that ,i th...Hi dear.<BR/>I have a problem in a situation that ,i think, is described by your post.<BR/><BR/>I need to call, in a trigger, java stored procedure that try to execute DML on table of trigger.<BR/><BR/>I make trigger an AUTONOMOUS TRANSACTION, but now i have ORA-00060: deadlock error.<BR/><BR/>ideas?<BR/>Tnx from ItalyAnonymousnoreply@blogger.com