Collection - Allround Automations forums

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:

Code

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'.