Re: SELECT returns different recordsets in different tools?!
From: Hans Forbrich <forbrich_at_telusplanet.net>
Date: Sat, 28 Jun 2003 20:37:22 GMT
Message-ID: <3EFDFAC5.EA484176_at_telusplanet.net>
Date: Sat, 28 Jun 2003 20:37:22 GMT
Message-ID: <3EFDFAC5.EA484176_at_telusplanet.net>
Valentin Tihomirov wrote:
> Hi,
> I've inserted a record with a key 'ACC'. A select showed me that it is still
> absent in the table. The repeated INSERT resulted with PK_CONSTRAINT. I have
> investigated the problem. The resultset has > 0 records but the desired
> record is absent in the result when selecting from four different clients
> (tools). The only tool that shows the record is PL/SQL Developer. Can
> anybody explain the phenomena?
>
> The database is Oracle we trust.
Real dumb question from me - did you commit from the tool/user where you inserted before you looked with the other tools? (Or are you hoping for something like a dirty read capability?)
/Hans Received on Sat Jun 28 2003 - 22:37:22 CEST