Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Antw: comments on 8i's autonomous PL/SQL block?
Hi maa,
I'm a bit unsure about what you mean. I never heard of the term 'autonomous block'. If it's 'autonomous transaction' that you're after, just have a look at the 'PL/SQL User's Guide and Reference' manual. It explains this point very well.
Greetings,
Guido
>>> maryann_30_at_yahoo.com 23.07.2003 21.04 Uhr >>>
Does anyone have any examples on the autonomous block
provided in 8i? I read that it can have a transaction scope
thats independent of the transaction scope of the calling block,
and that it can perform operations, commit and rollback
independent of the transactions of the calling block, before
returning to the calling block?
How is that? Does it mean it can start a transaction, update something, commit the change, and then return to the calling block where a change may still be uncommitted, even though the called block issued a commit?
thx
maa
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maryann Atkinson INET: maryann_30_at_yahoo.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu Jul 24 2003 - 00:45:51 CDT
![]() |
![]() |