Debugger not working

[WexSoft]

Hi Folks

Yesterday I tried to do some debugging but the debugger did not seem to be working correctly. This morning I did some further investigation on it. I created a new test window, and replaced the default test code with this script:

DECLARE
v_jira1 VARCHAR2(50) := 'test';
v_jira2 VARCHAR2(50);
BEGIN
SELECT v_jira1 INTO v_jira2 FROM dual;
dbms_output.put_line(v_jira2);
END;

I then clicked on the Start Debugging icon, and all the debugging icons remained grayed out. After 3 minutes I clicked the Terminate icon, but nothing happened. After clicking it about 10 times, the debugging icons where enabled, and a message dialogue was displayed with no text in it, and the width of it was so large that after dragging it left to right 3 times I still could not see the close button, so I just pressed the Enter key and it disappeared.

This was all done while running in DebugSQL mode (I will email the Debug.txt file to support@allroundautomations.com - note that when unzipped it is nearly 16 MB in size).

Here are my support settings:

PL/SQL Developer
Version 9.0.1.1613
01.72706 - 1 user license
Windows 2000 Professional 5.0 Build 2195 (Service Pack 4)

Physical memory : 1,570,888 kB (661,320 available)
Paging file : 2,990,556 kB (2,220,876 available)
Virtual memory : 2,097,024 kB (1,955,528 available)

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

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

Preference Files
C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
C:\Program Files\PLSQL Developer\Preferences\billy.crosbie\default.ini

Plug-Ins
*Browser Extender version 2.0 by Joachim Rupik (C:\Program Files\PLSQL Developer\PlugIns\be.dll)
*ColumnEdit v1.1 (C:\Program Files\PLSQL Developer\PlugIns\ColumnEdit.dll)
*Comment lines v1.4 (C:\Program Files\PLSQL Developer\PlugIns\commentline.dll)
*Editor Enhancement v1.0 (C:\Program Files\PLSQL Developer\PlugIns\editorenhancement.dll)
*Favorites v2.1 (C:\Program Files\PLSQL Developer\PlugIns\Favorites.dll)
*InitCaps v1.0 (C:\Program Files\PLSQL Developer\PlugIns\initcaps.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files\PLSQL Developer\PlugIns\plsqldoc.dll)
*Shift-Tab v1.0 (C:\Program Files\PLSQL Developer\PlugIns\shifttab.dll)
*PL/SQL Developer Sort Plug-In version 2003-11-05 (C:\Program Files\PLSQL Developer\PlugIns\Sort.dll)
*Toggle Read-Only v1.0 (C:\Program Files\PLSQL Developer\PlugIns\togglereadonly.dll)
*Version Control Interface 1.2 (C:\Program Files\PLSQL Developer\PlugIns\VCS.dll)
(* is Active)

Aliases

Homes
OraDev10 (C:\Oracle\OraDev10)
OraHome92 (C:\oracle\ora92)
OraHomeDS (C:\oracle\orads)
OUIHome1 (C:\OraHome_1)
OUIHome2 (C:\OraHome_2)

DLLs
C:\Oracle\OraDev10\bin\oci.dll

TNS File
G:\Oracle\Dept TNS File\tnsnames.ora\tnsnames.ora

Using
Home: OraDev10
DLL: C:\Oracle\OraDev10\bin\oci.dll
OCI: Version 10.1
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0

Character Sets
Character size: 1 byte(s)
CharSetID: 46
NCharSetID: 2000
Unicode Support: True
NLS_LANG: ENGLISH_IRELAND.WE8ISO8859P15
NLS_CHARACTERSET: WE8ISO8859P15
NLS_NCHAR_CHARACTERSET: AL16UTF16

If you need any other details on this, let me know.

Best regards

Billy

 

[Marco Kalter]

This script works just fine for me on Oracle 10.2, but we'll check out your log file.