Missing Full Preview of Collection Variables During Debugging in PL/SQL Developer

[Blue306]

Hi everyone,

I’ve noticed a limitation while debugging PL/SQL code in PL/SQL Developer and wanted to ask if others have experienced the same.

When working with collection types (e.g., associative arrays, nested tables, or VARRAYs), the debugger does not always show a full preview of all elements. In many cases, only part of the data is visible, or the structure cannot be expanded completely in the variables/watch window.

 

[Marco Kalter]

Can you provide an example?

 

[Blue306]

EXAMPLE CODE:

TYPE TDataRec IS RECORD (
sid v$session.sid%TYPE,
serial# v$session.serial#%TYPE,
job_name dba_scheduler_running_jobs.job_name%TYPE,
action v$session.action%TYPE,
module v$session.module%TYPE,
logon_time v$session.logon_time%TYPE,
elapsed_time dba_scheduler_running_jobs.elapsed_time%TYPE,
program v$session.program%TYPE,
last_call_et v$session.last_call_et%TYPE,
blocking_session v$session.blocking_session%TYPE,
status v$session.status%TYPE,
sql_id v$session.sql_id%TYPE,
sql_text v$sql.sql_text%TYPE,
username v$session.username%TYPE,
type v$session.type%TYPE,
seconds_in_wait v$session.seconds_in_wait%TYPE
);


TYPE TDataTab IS TABLE OF TDataRec;
ltData TDataTab;

later in code:

SELECT ...
BULK COLLECT INTO ltData
FROM ...;

When I try to inspect the variable ltData in the debugger, it displays only:

I cannot expand it or view individual elements or fields so it's impossible to debug data inside the record collection.

 

[Marco Kalter]

Collections of compound data types are indeed not yet supported. This is on the list of enhancement requests.