>> Think he want that read only the data that IS committed and "the record
>> with id 10104 isn't already committed".
>
> That's it! I just want to read the records that are committed. I don't
> even want to read a VERSION of uncommitted records.

There's multiple ways to do this --

Read a snapshot (for data consistency while reading) or simply reading
"committed",
which might return inconsistent data during the read, as other transactions
may commit
changes.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com