SELECT returns different recordsets in different tools?!

[Valentin Tihomirov]

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.

[Ed Prochak]

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.

Did you do a COMMIT WORK; in the session that did the insert?

If you don't commit, then other sessions cannot and should not see your
partial transaction.

--
Ed Prochak
running http://www.faqs.org/faqs/running-faq/
netiquette http://www.psg.com/emily.html
--
"Two roads diverged in a wood and I
I took the one less travelled by
and that has made all the difference."
robert frost

[Ed prochak]

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@magicinterface.com