PLSQL Developer hangs when inserting row

[jlt]

Hello,

We noticed a problem when inserting rows :

Example :
We have 2 tables with a foreign key :

TABLE1 TABLE2
------ ------
Primary Key : Primary Key :
COL1

 

[Marco Kalter]

You can only solve this by using "Dual Session" session mode. The problem is that the 2 windows use 2 sessions, and one will lock the other. Updates from the grid are not applied in a background thread, so PL/SQL Developer will hang in case of a deadlock. For inserts, PL/SQL Developer cannot first test for locks.

 

[jlt]

Do you think it could be an evolution in a future version of PLSQL Developer ?

 

[Marco Kalter]

That would certainly be an option.