Re: SELECT returns different recordsets in different tools?!

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