OCI, host arrays and where clause

Is it possible to use arrays in OCI in the where clause of a select statement? Consider the following:

...

const char fooArr[2][4]= { "one", "two" }; const char *stmt=

        "select foo, bar from blah where foo = :fooArr"
...

When executed the statement should be equivilent to

select foo,bar from blah where foo = 'one' union
select foo,bar from blah where foo = 'two'

-- 
Kelly R. Burkhart
nospam mailto kburk at sky dot net