OK, one case it happens is, when the array is a parameter.

I am also facing this problem which is seriously affecting my developement since the entire code is based on collections.
The "View Collection Variable" option used to work just fine till we upgraded our server from 8.1.7 to 9.2.0.4. Simultaneously I moved from Windows/2000 to XP.

Since then whenever viewing a collection variable, the entire pl/sql developer hangs.

Just today, the company upgraded to PL/SQL developer 5.1.6 version thinking the bug would be fixed in this version. But the thing still hangs.

I have bunch of collections of strictly scalar data type. Most of them are defined along following lines:

create or replace type MediumCharList as varray(4000) of varchar2(4000);

Variables used inside PL/SQL code are mostly of type MediumCharList.

The problem can be narrowed down to Oracle 9.2.0.1 specifically since none of the older and newer versions of PL/SQL developer now work for "View Collection" option. And before we migrated from Oracle 8.xx to 9.2, atleast the older versions of PL/SQL developer *were* working correctly. Any clues what it might be in Oracle 9.2.0.1 that is not allowing a successful "View Collection"?

No clue yet. What is your server operating system?

In the debugger, when I rightclick on an array and then chose "view collection variable"
pl/sql developer freezes.

- My PL/SQL Developer version is 6.0.0.810
- My OS is Windows XP Professional version 2002 (Service Pack 1)
- Database version is Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
- Clients versions: SQL*Plus: Release 9.2.0.1.0 or
SQL*Plus: Release 8.1.7.0.0 (two oracle homes)

** In debbuger example:

1. Type gt_Vetor Is Table Of VarChar2(50) Index By Binary_Integer;
2. Type gt_Matriz Is Table Of gt_Vetor Index By Binary_Integer;

3.
CREATE OR REPLACE Procedure PRC_TEST Is
vt_Test gt_Matriz;
begin
-- Load vt_Test
vt_Test := pkgl_newsic_ch.fncl_get_tab_centrais_est;

If vt_Test(2)(2) = 'xxx' Then --> here PL/SQL Developer freezes, when mouse enter over "vt_Test(2)(2)" !!
dbms_output.put_line('1');
Else
dbms_output.put_line('2');
End If;
End;
/

Tks !!

[]'s,
Luciana Angeli

Any progress on this issue by the Allroundautomations Team? This bug has made PL/SQL debugger practically useless to me.

Not really. Can you let me know your Oracle Server Operating System?

Hello,

I just tried with PL/SQL Developer 7.1.0 (beta 3), and I still can reproduce this problem.... I'm using Oracle server 9.0.2.7.0. Couldn't you fix it?

Best regards,
Laurent Feltz

i think this somehow related to this one:

topic

It's not only bi dimensional varrays, but normal varrays too . Here a simple test case (with server 9.2.0.7 and pl/sql dev 7.1 beta 3):

As I can read in this post, it seems that it doesn't with oracle databases >= 9.2.0.1

Marco: Could you try this test case using a database like 9.2.0.x? Do you confirm the problem?

CREATE OR REPLACE TYPE "AR_NUM" AS VARRAY(2147483647) OF NUMBER;

CREATE OR REPLACE PROCEDURE test_varray ( par IN ar_num)
IS
BEGIN
IF
par IS NOT NULL
THEN
dbms_output.put_line('<NOT NULL>'); // Breakpoint here -> PL/sql Dev freezes when I try to watch from here the parameter "par"
END IF;
RETURN;
END test_varray;


-- Test script
declare
-- Local variables here
lar ar_num := ar_num (1, 2, 3);
begin
test_varray (par => lar);
end;

Laurent.