Collection variable - debugger hangs when viewing it

[sanjana]

I have been debugging why PL/SQL developer does not show the Collection Variable properly when it used to do so quite some time back. This is what I get in my Tools->Sessions which I map to V$_SQLTEXT:
declare runtime_info sys.dbms_debug.runtime_info;
begin sys.
dbms_debug.default_timeout := :default_timeout;
runtime_info.program.namespace := null;
runtime_info.program.name := null;
runtime_info.program.owner := null;
runtime_info.program.dblink := null;
runtime_info.line# := null;
runtime_info.terminated := null;
runtime_info.breakpoint := null;
runtime_info.stackdepth := null;
runtime_info.interpreterdepth := null;
runtime_info.reason := null;
sys.dbms_debug.attach_session(debug_session_id => :debug_session_id);
:sync_result := sys.dbms_debug.synchronize(run_info => runtime_info, info_requested => sys.dbms_debug.info_getStackDepth +
sys.dbms_debug.info_getLineInfo +
sys.dbms_debug.info_getBreakpoint);
rogram_namespace := runtime_info.program.namespace;
rogram_name := runtime_info.program.name;
rogram_owner := runtime_info.program.owner;
rogram_dblink := runtime_info.program.dblink;
:line# := runtime_info.line#;
:terminated := runtime_info.terminated;
:breakpoint := runtime_info.breakpoint;
:stackdepth := runtime_info.stackdepth;
:interpreterdepth := runtime_info.interpreterdepth;
:reason := runtime_info.reason;
sys.dbms_debug.default_timeout := 3600;
end;

QUESTION: Why is the DBMS_DEBUG.DEFAULT_TIMEOUT set so long? That's why the debugger "seems" to hang. Is it something set by default in my Oracle database?

Oracle Database: Oracle9i Release 9.2.0.4.0
OS - Sun Sparc, hardware = sun-v480
PL/SQL developer: 7.0.2.1076

 

[Marco Kalter]

The time-out value is supplied by PL/SQL Developer. We could set it lower, but you don't want the debugger to fail because a debug step takes longer than a specified amount of time.

 

[sanjana]

Marco,
Now that you have the complete information, any idea why the Collection Variables are unviewble? These are simple collection variables of scalar type - the ones that the PL/SQL developer supports.