Return
-
Title
Debugger. How to populate parameter window using table type parameter coming in (records coming i -
Description
Debugger. How can I populate the parameter window using table type parameter coming in. I need to automatically populate the input parameters using data or values coming in from an existing table so that I do not have to manually type it in.
-
Resolution
Toad does not have that functionality to automatically input parameter values coming in from a table. It will need to be written in the PL/SQL code itself in order to input values or records coming from a table.
-
Additional Information
It is also possible to change (add the values) directly from the anonymous block generated in the lower half of the Parameter window.ÂFor example, you can change the entries:Â-- IN_VARRAY := NULL; Modify the code to initialize this parameterÂtoÂIN_VARRAY := varray_type01('dog', 'cat', 'mouse');