Re: trying to understand transaction control in pl/sql

From: ken quirici <kquirici_at_yahoo.com>
Date: 26 Oct 2004 06:16:47 -0700
Message-ID: <eeca902a.0410260516.58ac5218@posting.google.com>

Kenneth Koenraadt wrote in message news:<417d26ae.832968_at_news.inet.tele.dk>...
>
> Hi Ken,
>
> An *UNHANDLED* exception causes the on-going transaction to be rolled
> back. In the second example you handle the exception, thus no
> rollback.
>

Hi Kenneth,

Does this mean a transaction in a pl/sql unnamed block (to start with) runs from the start of the block to the first commit or rollback or savepoint or set transaction? The second to the next, etc. (except for called autonomous transaction procs)? So each statement in the pl/sql unnamed block is not itself a transaction, even though they would be if individually typed in sequence at the sqlplus prompt?

Hope I'm being clear.

Thanks again for your reply.

Ken Received on Tue Oct 26 2004 - 08:16:47 CDT