Re: How to pass an Integer Array to a Stored Procedure?

[Jim Kennedy]

"2much4u" <r...@2much4u.net> wrote in message
news:8fKdnUHgH86...@giganews.com...
> Hello,
>
> I have a stored procedure and I want to pass it a NUMBER parameter to
> make a select inside it as the following:
>
> SELECT *
> FROM example_table
> WHERE example_table.id IN (1,3,4,6,7,8,234);
>
> I want to pass the Stored Procedure "1,3,4,6,7,8,234" as a Integer
> Array, is this possible?
>
> Thanks & Regards.

Look on asktom.oracle.com and search. Basically you need to make a type,
and a table of that type and parse the string into an array of the type and
cast it. Tom has a nice example of it. I think searching for bind variable
in list will find it.
Jim