Re: Autonomous Transactions

devjnr_at_gmail.com wrote:
> Connor McDonald ha scritto:
>
> > remove the 'commit'
>
> Commit is part of logic of transtaction, isn't it?

Yes, of course.

> Why do I have to remove it?

Because otherwise you are committing things you don't want committed.

> According to doc:
>
> http://download-uk.oracle.com/docs/cd/B19306_01/appdev.102/b14251/adfns_s
> qlproc.htm#i1007356
>
> AT can have commit or rollback inside them...

Once you remove the "pragma autonomous_transaction;" you no longer have an AT. Why would expect a non-AT to behave like an AT? Since your question is about what happens when you are *not* using an AT, then you shouldn't be expecting the AT docs to explain it.

If it is not an AT, then it is part of the outer transaction. If it part of the outer transaction, then what do you expect commit to do, other than commit the outer transaction?

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB