Re: SELECT returns different recordsets in different tools?!
Date: 30 Jun 2003 06:30:47 -0700
Message-ID: <a1d154f4.0306300530.51cbcd5d_at_posting.google.com>
"Valentin Tihomirov" <valentin_at_abelectron.com> wrote in message news:<3f000d7b$1_1_at_news.estpak.ee>...
> When I requested an insert of multipe records (with autocommit after each
> SQL stmt) the client stalled and I'd cancelled the operation. Seems you're
> right, the problem was with commit.
> However, I think that database should not return uncommited data on SELECTs.
> The connection type of PL/SQL is strange. Once when OCI connection (don't
> know what is it) to Oracle was broken (none of tools could connect to it);
> the PL/SQL still could. That is, PL/SQL has a direct connection to Oracle
> granting it access to the secret areas of this database.
Nonsense
Sybrand Bakker
Senior Oracle DBA
Received on Mon Jun 30 2003 - 15:30:47 CEST