comments on 8i's autonomous PL/SQL block?

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 Received on Wed Jul 23 2003 - 13:00:32 CDT