How to use the debugger to watch collection variables in a Package?
There is a limitation of the DBMS_Debugger package to watch a collection variable.
There will be a need to fetch a single record into a single record then set the watch on a variable. Here is an example in what to add to the code:
then set tmp_var :=test(i).store_id
The "test(i).store_id" is the collection variable similar to an array. Therefore, add the watch on the "tmp_var" variable then step through the code to get a value.