-
autonomous_transaction
Dear all, Can any one please help me why deadlock is happening here.
SQL> create table gtt ( x int primary key )
2 ;
Table created.
SQL> insert into gtt values ( 1 );
1 row created.
SQL> commit;
Commit complete.
SQL> update gtt set x = 1;
1 row updated.
SQL> declare
2 pragma autonomous_transaction;
3 begin
4 delete from gtt where x = 1;
5 end;
6 /
declare
*
ERROR at line 1:
ORA-00060: deadlock detected while waiting for resource
ORA-06512: at line 4
SQL>
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|