create type StringTable as table of varchar2(4000); select A.dummy, B.column_value from dual A, table(StringTable('one', 'two', 'three')) B; #### DUMMY COLUMN_VALUE ----- ------------------ X one X two X three #### StringTable('one', 'two', 'three') #### begin myproc(?, StringArray(?,?,?)); end;