|
|
 Debugger Hangs on Array
|
Joined: Jun 2003
Posts: 52 Lenzburg, Switzerland
Member
|
OP
Member
Joined: Jun 2003
Posts: 52 Lenzburg, Switzerland |
In the debugger, when I rightclick on an array and then chose "view collection variable" pl/sql developer freezes. The array is of a schema level defined type.
|
|
|
 Re: Debugger Hangs on Array
|
Joined: Aug 1999
Posts: 22,279
Member
|
|
Member
Joined: Aug 1999
Posts: 22,279 |
Can you let me know your PL/SQL Developer version? Can you also let me know the definition of the array?
Marco Kalter
Allround Automations
|
|
|
Re: Debugger Hangs on Array
|
Joined: Jun 2003
Posts: 52 Lenzburg, Switzerland
Member
|
|
OP
Member
Joined: Jun 2003
Posts: 52 Lenzburg, Switzerland |
Oops, I slept on that one. But the Problem ist still there. I have Pl/SQL Developer 5.1.6.747 and it happens with all varrays (I Think), like a schema level defined "VARRAY(2147483647) OF NUMBER";
|
|
|
Re: Debugger Hangs on Array
|
Joined: Aug 1999
Posts: 22,279
Member
|
|
Member
Joined: Aug 1999
Posts: 22,279 |
I the array defined within a package or through a "create or replace object" statement?
Marco Kalter
Allround Automations
|
|
|
Re: Debugger Hangs on Array
|
Joined: Jun 2003
Posts: 52 Lenzburg, Switzerland
Member
|
|
OP
Member
Joined: Jun 2003
Posts: 52 Lenzburg, Switzerland |
The Array is defined with:
CREATE OR REPLACE TYPE AR_NUM AS VARRAY(2147483647) OF NUMBER;
It shows up in pl/sql Developer in the "Types" Folder
|
|
|
Re: Debugger Hangs on Array
|
Joined: Aug 1999
Posts: 22,279
Member
|
|
Member
Joined: Aug 1999
Posts: 22,279 |
Works fine for me. What is your server version?
Marco Kalter
Allround Automations
|
|
|
Re: Debugger Hangs on Array
|
Joined: Jun 2003
Posts: 52 Lenzburg, Switzerland
Member
|
|
OP
Member
Joined: Jun 2003
Posts: 52 Lenzburg, Switzerland |
This happens on Oracle 9.2.0.4
I am quite positive, that it happened on older versions as well. On Windows Nt Server and on Linux Machines. In Fact i have never seen it Working, except for PL/SQL Tables.
|
|
|
Re: Debugger Hangs on Array
|
Joined: Jun 2003
Posts: 52 Lenzburg, Switzerland
Member
|
|
OP
Member
Joined: Jun 2003
Posts: 52 Lenzburg, Switzerland |
Where you able to reproduce the bug yet?
|
|
|
Re: Debugger Hangs on Array
|
Joined: Aug 1999
Posts: 22,279
Member
|
|
Member
Joined: Aug 1999
Posts: 22,279 |
Not yet. It's quite odd that you have had this problem on various platforms / versions, and that we cannot reproduce it.
Marco Kalter
Allround Automations
|
|
|
Re: Debugger Hangs on Array
|
Joined: Jun 2003
Posts: 52 Lenzburg, Switzerland
Member
|
|
OP
Member
Joined: Jun 2003
Posts: 52 Lenzburg, Switzerland |
Seems odd, yes. I just tried a simple test case and the Problem is non existant then. I will try to find what breaks it.
|
|
|
|
|
|
|
