How to pass an Integer Array to a Stored Procedure?
From: 2much4u <rsv_at_2much4u.net>
Date: Fri, 04 Mar 2005 17:37:12 +0100
Message-ID: <8fKdnUDgH86uDbXfRVnytg_at_giganews.com>
Hello,
Date: Fri, 04 Mar 2005 17:37:12 +0100
Message-ID: <8fKdnUDgH86uDbXfRVnytg_at_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. Received on Fri Mar 04 2005 - 17:37:12 CET