SQL Window - Variables causing hang

[MjH]

For some reason, PL/SQL Developer has started this morning hanging when running code in a SQL Window that does variable substitution. For example:

select * from dual where 1 = &;

The word "Initializing" appears bottom status bar, but no pop-up window prompting for the variables appears. Clicking anywhere on the main window gets no response, even the minimize and close window icons in the top-right hand corner of the window. The only thing that can be done is to kill the process from the Task Manager.

I use lots of scripts every day that use variable substitution, so this is making it unusable.

Any thoughts what might be causing the problem and suggested solutions?

Here is the data from Help -> Support Info:

PL/SQL Developer
Version 12.0.7.1837 (64 bit)
01.107809 - 50 user license
Service Contract: 01-Jun-2017
Windows 10 Build 17134

Physical memory : 25,047,632 kB (18,826,776 available)
Paging file : 28,717,648 kB (22,108,600 available)
Virtual memory : 137,438,953,344 kB (137,434,276,064 available)

Parameters
C:\Program Files\PLSQL Developer 12\plsqldev.exe

Preferences
Session mode: Dual
OCI Library:
Use OCI7: False
Allow Multiple Connections: False

Preference Files
C:\Users\mhammel\AppData\Roaming\PLSQL Developer 12\Preferences\default\Default.ini
C:\Users\mhammel\AppData\Roaming\PLSQL Developer 12\Preferences\mhammel\default.ini

License File
C:\ProgramData\PLSQL Developer\aalf.dat

Debug file
C:\Users\mhammel\AppData\Roaming\PLSQL Developer 12\PlSqlDev.elf

Plug-Ins
*Active Query Builder (C:\Program Files\PLSQL Developer 12\PlugIns\ActiveQueryBuilder.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files\PLSQL Developer 12\PlugIns\plsqldoc.dll)
(* is Active)

Aliases

Homes
OraClient12Home1 (C:\Oracle\product\12.1.0\client_1)

DLLs
C:\Oracle\product\12.1.0\client_1\bin\oci.dll

TNS File
C:\Oracle\product\12.1.0\client_1\Network\Admin\tnsnames.ora

Using
Home: OraClient12Home1
DLL: C:\Oracle\product\12.1.0\client_1\bin\oci.dll
OCI: version 12.1 (12.1.0.2.0)
Oracle Database 11g Release 11.2.0.3.0

Character Sets
Character size: 4 byte(s)
CharSetID: 873
NCharSetID: 2000
Unicode Support: True
NLS_LANG: AMERICAN_AMERICA.WE8MSWIN1252
NLS_CHARACTERSET: AL32UTF8
NLS_NCHAR_CHARACTERSET: AL16UTF16

Process
Working Set = 139,853,824
Memory = 47,414,032
GDI Objects = 595
User Objects = 285
Handles = 502

Monitors
PixelsPerInch = 96

Id = 0
Primary = True
Handle = 65604
Left = 0
Top = 0
Width = 1920
Height = 1080

Id = 1
Primary = False
Handle = 131073
Left = -1920
Top = 0
Width = 1920
Height = 1080

MainFormOnTaskbar = False

 

[MjH]

I also tried uninstalling, rebooting and re-installing PL/SQL Developer. Also removing my preferences directory so it is reset to default by PL/SQL Developer.

No change....

 

[Marco Kalter]

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

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

Delete the SubstVarForm key in this section, restart PL/SQL Developer, and try again.

 

[MjH]

Yes! That did it, thanks Marco.