Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: keep select in transaction
Rene Nyffenegger wrote:
> >> Based on my understanding of your understanding of my
understanding,
> >> etc. you are wrong on all counts.
> >>
> >> if a single DML statement, or PL/SQL call doesn't end with either
> >> COMMIT or ROLLBACK the statement has not ended. What happens next
> >> is still part of the same transaction.
>
> > So it all boils down to... did you mean transaction as a single
plsql
> > call or did you mean transaction as a single DML?
>
> A transaction is well defined. From
>
http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10743/transact.htm#CNCPT117
>
> A transaction is a logical unit of work that contains one or more SQL
> statements. A transaction is an atomic unit. The effects of all the
SQL
> statements in a transaction can be either all committed (applied to
the
> database) or all rolled back (undone from the database).
>
> A transaction begins with the first executable SQL statement. A
transaction
> ends when it is committed or rolled back, either explicitly with a
COMMIT or
> ROLLBACK statement or implicitly when a DDL statement is issued.
>
> So, regarding transactions, Daniel is right. Nevertheless, I still
stand
> by my observation that Oracle can see data commited in an (other)
> transaction whose commit time was after the 'first' transaction
begun.
>
> Rene
>
I am well aware of the definition of a transaction but thanks for the explanation. You may want to ask Daniel how he meant it (as I inquired) because his statement is incorrect if transaction is defined as above... but correct if transaction is defined as a single DML.
I was defending his statement by giving him the benefit of the doubt... which was mistake on my part as I now realize it. His original statement and the followup definition are completely contradictory to each other.
This thread is getting confusing. Not sure who meant what in their post.
Regards
/Rauf
Received on Fri Apr 15 2005 - 16:41:29 CDT
![]() |
![]() |