| what is autonomous pragma transaction in function and procedure [message #135976] |
Mon, 05 September 2005 03:58  |
dsuresh99
Messages: 1
Registered: September 2005
Location: chennai,india |
Junior Member |
|
|
|
what is autonomous pragma transaction in function and procedure
[Updated on: Mon, 05 September 2005 04:46]
|
|
|
|
| Re: what is autonomous pragma transaction in function and procedure [message #319696 is a reply to message #135997 ] |
Mon, 12 May 2008 13:24  |
dasgupta.amitava@gmail
Messages: 26
Registered: November 2007 |
Junior Member |
|
|
Hi all,
few days back I came accross the PRAGMA AUTONOMOUS_TRANSACTION clause in pl/sql. Can anybody tell me that whether an autonomous transaction suspends the main transaction or not?? i.e. the main transaction and the auto. transaction can run at the same or the main transaction has to wait for the auto. transaction...
Thanks in advance
Amitava.............
|
|
|
| Re: what is autonomous pragma transaction in function and procedure [message #319700 is a reply to message #319696 ] |
Mon, 12 May 2008 13:51 |
Michel Cadot
Messages: 17697
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
The main transaction is suspended during the execution of the autonomous transaction but it is still there with its locks and modifications that the autonomous transaction can't see.
Regards
Michel
|
|
|
| Re: what is autonomous pragma transaction in function and procedure [message #319753 is a reply to message #135976 ] |
Mon, 12 May 2008 23:26 |
srinu_erp
Messages: 3
Registered: January 2008 |
Junior Member |
|
|
Hi,
If uyou define a pl/sql block as an autonomous transaction then if there are any changes to the parent block will not effect the child block. An autonomous transaction may end with commit or rollback and one autonomous transaction per one pl/sql block is allowed.
regards,
srinu
[Updated on: Mon, 12 May 2008 23:26]
|
|
|
| Re: what is autonomous pragma transaction in function and procedure [message #319853 is a reply to message #319753 ] |
Tue, 13 May 2008 04:01 |
JRowbottom
Messages: 3069
Registered: June 2006
Location: Sunny North Yorkshire, ho... |
Senior Member |
|
|
one autonomous transaction per one pl/sql block is allowed.
Not really. A pl/sql block is either Autonomous, or not, depending on whether the PRagma is included in the Declare section, but a Pl/Sql block may execute as many different autonomous transactions as it likes.
|
|
|
| Re: what is autonomous pragma transaction in function and procedure [message #319855 is a reply to message #319853 ] |
Tue, 13 May 2008 04:04 |
Littlefoot
Messages: 6168
Registered: June 2005
Location: Croatia, Europe |
Senior Member |
|
|
|
I.e. there are no limits but resource limits.
|
|
|
]
Members
Search
Help
Register
Login
Home
