bug 6.0.3.893

[oraclelover]

I have simple select statement that I query from a table. I than go to sqlplus session and update a value on that table for a given record. This is same record I selected from in pl/sql devleoper.

I commit
I query in sqlplus and my update is showing
I go back to same pl/sql devleper sql window and requery change not showing
I open new sql window in pl/sql developer and the new value is there
I go back to origanal window in pl/sql developer where value is not showing and requery and still don't see the change.

When I get time I will try to reproduce this issue.

Any ideas?

 

[oraclelover]

I tried to reproduce this and can't I'll make sure to reply back to this message if I get this. Has anyone else ever had this issue? Or a variation of this?

 

[Marco Kalter]

It seems as though the transaction isolation level is set to serializable in PL/SQL Developer. Could this be the case? If so, executing a commit in the SQL Window and subsequently requerying the updated data should do the trick.