FAQ: How can I test a program unit with a PL/SQL Table parameter?

[faq]

I have a program unit that has a PL/SQL Table parameter. When I generate a Test Script, I cannot set or view the values of the PL/SQL Table.

 

[support]

The Test Window does not directly support collection data types as bind variables. For PL/SQL tables you need to pass a local variable of the same type as used in the program unit. For example, the dbms_output.get_lines procedure returns lines in a PL/SQL Table of strings (type dbms_output.chararr), and can be tested with the following script:

declare
  lines dbms_output.chararr;
begin
  dbms_output.enable;
  dbms_output.put_line('Hello');
  dbms_output.put_line('World');
  :numlines := 2;
  dbms_output.get_lines(lines, :numlines);
  :line1 := lines(1);
  :line2 := lines(2);
end;