Re: Input array string

roger wrote:

> That's a handy reference page with some interesting info.
> Unfortunately, it doesn't address the question the poster is asking.
>
> He is saying that he's got some application with an array of
> values that he wishes to pass to a stored procedure, for use
> in an SQL statement IN clause.
>
> Nothing about using the InStrTab table type is going to help
> him to pass those values to the stored procedure.

That is a long way from saying you can't pass an array to a stored procedure: You can:

http://asktom.oracle.com/pls/ask/f?p=4950:8:4392192797026934757::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:208012348074,

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)