Debugging PL/SQL Collections using PL/SQL Developer

[Victor ITR]

Is it possible to view the contents of the collection in the debug window in PL/SQL Developer?
PL/SQL Developer, version 10.0.5.1710
https://stackoverflow.com/questions/56743758/

 

[Marco Kalter]

No, this is currently not possible.

 

[rbrooker]

Hi Marco,

Is this a PLSD limitation or an Oracle debugger limitation? I am using 13.6 and would like to be able to view collection contents also.

cheers.

 

[Worker]

Same here. We use a lot of collections-of-records and better support for these in the debugger would be helpful.

 

[Marco Kalter]

It's both a PL/SQL Developer and Oracle Debugger limitation. The Oracle Debugger cannot return complete collection data, but PL/SQL Developer could be enhanced to analyze the collection data type and fetch all individual collection instances and attribute values.

I have added this to the list of enhancement requests.

 

[Vio]

Hi, do we have news about this?