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

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:[quote]

Code

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;

[/quote]