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,

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

Original text of this message