Re: SELECT returns different recordsets in different tools?!

Valentin Tihomirov wrote:
> 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.

okay, so the original problem was a misunderstanding, not a real problem.

> However, I think that database should not return uncommited data on SELECTs.

And oracle doesn't, except in the sessionthat has the pending inserts.

> 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.
>
>

You speak of PL/SQL connecting, but there is no such thing. PL/SQL doesn't connect to ORACLE because PL/SQL programs run in the server.

Perhaps you are speaking of SQL/PLUS??? BIG difference between SQL/PLUS and PL/SQL

Don't know what you mean by saying your OCI connection was broken. What error did your program report? there are too many possibilities to think about.

I'd order a new crystal ball, but I think Bill Gates is hording them all.

-- 
Edward J. Prochak   --- Magic Interface, Ltd.
Ofc: 440-498-3700   --- 7295 Popham Place, Solon, OH 44139
on the web at       --- http://www.magicinterface.com
email: ed.prochak_at_magicinterface.com