In a Test Window you can call the procedure with a local collection type variable, and subsequently open a cursor variable for the collection results. Declare the cursor variable as a bind variable of type 'Cursor' so that you can subsequently view the collection cursor result set. For example:
declare
my_collection my_collection_type;
begin
my_ccollection_procedure(my_collection);
open :my_collection_cursor for select * from table(my_collection);
end;
In this case :my_collection_cursor should be declared as a bind variable of type 'Cursor'.
