SQL Window with sql prompt not opening in foreground - program stuck!

Jeff81

Member³
I recently starting having a problem with queries that have an "&" to prompt user for a value. When the query executes the dialog never pops up but the PLSQL Dev program stuck waiting for that window to close. The dialog box is no where to be found. I can't bring it to the front. I've tried minimizing all my other windows. This randomly starting happening a few weeks ago. Same issue also with version 14 beta.
I have to end task on my program when this happens.

One thing I have noticed is that I use crash recovery and tend to have a multiple sessions waiting to be recovered. So when I open a new instance of PLSQL Dev the crash recovery window will pop up and I chose an instance to recover but not sure if the window fully goes away.

Any ideas?

 
Can you start regedit.exe and go to the following section?

For PL/SQL Developer 11.0 and earlier:

HKEY_CURRENT_USER\Software\Allround Automations\PL/SQL Developer\Position

For PL/SQL Developer 12.0 and later:

HKEY_CURRENT_USER\Software\Allround Automations\PL/SQL Developer [version]\Position

Delete the SubstVarForm key in this section, restart PL/SQL Developer, and try again.
 
I'm having the same issue when clicking the ellipses button next to text in the results panel. it opens off screen and can't do anything until I press the escape key to return control back to the main window. I deleted everything under the 'Position' registry key and restarted the program with no luck.

Please advise.
 
Did you exit PL/SQL Developer before clearing the "Position" key? I'm not sure what else could cause this.
 
Yes I did. None of the entries in the registry seem to apply to the field value editor (the one that lets you switch to plain text, hex, html, etc).
 
Back
Top