Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> How to pass an Integer Array to a Stored Procedure?

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@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 - 10:37:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US