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.

"2much4u" <rsv (AT) 2much4u (DOT) net> wrote

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