SELECT returns different recordsets in different tools?!
From: Valentin Tihomirov <valentin_at_abelectron.com>
Date: Sat, 28 Jun 2003 23:08:11 +0300
Message-ID: <3efdf628$1_1_at_news.estpak.ee>
Hi,
[Quoted] [Quoted] 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?
Date: Sat, 28 Jun 2003 23:08:11 +0300
Message-ID: <3efdf628$1_1_at_news.estpak.ee>
Hi,
[Quoted] [Quoted] 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. Received on Sat Jun 28 2003 - 22:08:11 CEST