Passing multi values into an in clause via a parameter in a store procedure

From: Berend <Berend.Brinkhuis_at_evatone.com>
Date: 27 Jan 2004 13:01:24 -0800
Message-ID: <bdd9ac20.0401271301.22cdb65e_at_posting.google.com>

I am trying to pass multi values into a where clause with an in clause in a store procedure to use in a Crystal report. This can change depending on the user. Maybe there is another way to pass multi values.

CREATE OR REPLACE PROCEDURE eva_sp_wrk014_spec_test (

   p_eva_product_header_ids   IN       VARCHAR2,
   cur_spec_cd                IN OUT  

sysadm.eva_pkg_wrk014_spec_test.ref_spec_spec_cd )
AS
BEGIN
   OPEN cur_spec_cd
    FOR

       SELECT *
         FROM sysadm.eva_product_header eph
        WHERE eph.eva_product_header_id in (p_eva_product_header_ids);

END eva_sp_wrk014_spec_test; Received on Tue Jan 27 2004 - 22:01:24 CET