How do you load a collection of values in the Set Parameters window? (4229176)

How do you load a collection of values in the Set Parameters window?

Does Toad have a way of loading, more than one input value or parameter at a time, rather than individually in the Set Parameters window?

In the Set Parameter window , there is a section for code that is the anonymous code block that Toad generates in order to debug the procedure. It will default the parameter to NULL and comment out the lines of code that initialize the parameters that are needed to debug.

The grid in the Set Parameter window will not be editable for paramters that require more than one value (i.e. parameter of type array) and to edit/add the values, you will need to go into the anonymous code block, uncomment this section and manually type in the values youd like to use for the debugging session.

Sample:
(colvar is of type VARRAY(10))

DECLARE
INPUTCOLLECTION colvar;
INPUTVAL NUMBER;
OUTPUTRESULTS colvar;

BEGIN
-- INPUTCOLLECTION := NULL; Modify the code to initialize this parameter
INPUTVAL := 1;
-- OUTPUTRESULTS := NULL; Modify the code to initialize this parameter
MATHEW.TEST_COLLECTION2 ( INPUTCOLLECTION, INPUTVAL, OUTPUTRESULTS );
COMMIT;
END;

This anonymous code block is what Toad runs to debug your proc. It declares the parameters required, and you initialize it by editing the commented section:

INPUTCOLLECTION := colvar(11, 22, 33, 44, 55); --Modify the code to initialize this parameter
INPUTVAL := 1;
-- OUTPUTRESULTS := NULL; Modify the code to initialize this parameter