This pl/sql block does not do any DML. The session he logs in with does no
DML. All it does is run a pl/sql block with a select inside a loop. If my
understanding is correct, unless I issue a "set transaction read only",
read consistency should start all over for each new select. That's the way
it works in pure SQL. Does that not hold true inside of pl/sql?
"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message
news:3DB57845.B7BCD4D5_at_exesolutions.com...
[snipped]
> A transaction starts with the first DML statement and ends with either
COMMIT
> or ROLLBACK. In a loop you can any darn thing you want ... and it is one
> transaction until you end it.
>
> Which does not mean that the solution is to put COMMIT into your loop.
That is
> almost always a bad idea. Far better to increase the size of your rollback
> segments.
>
> Daniel Morgan
>
Received on Tue Oct 22 2002 - 13:28:10 CDT
