I'm not sure what you want to pass an array for... but note that Oracle can use "tables" of literals in SQL. That might be a way to do what you want.

Here's the code in SQL that you can most likely also use in DBI:

create type StringTable as table of varchar2(4000);
select A.dummy, B.column_value
from dual A, table(StringTable('one', 'two', 'three')) B;
[download]

This example makes a chartesian join of data from system table dual (with 1 row of one column dummy having the value 'X') with my emulated table of literals, producing 1*3 = 3 rows:

DUMMY COLUMN_VALUE
----- ------------------
X     one
X     two
X     three
[download]

Likewise, if your stored procedure accepts a parameter of type StringArray, then you can just pass the data along this way:

StringTable('one', 'two', 'three')
[download]

Note that this will only work with table types where you don't specify index by, because the StringTable() here works as a constructor and that only works works with tables without index by.

The way to pass the data through the statement with placeholders, is by using as many placeholders as there are values:

begin
   myproc(?, StringArray(?,?,?));
end;
[download]

and pass a flat list of 4 values.