Stored procedure parameter

Hello,

Sorry for my english, i'll try to explain my problem

I'm working with Crystal Report X and i call a oracle stored procedure.

One of the parameter (ListOfPoint) of crystal is a multi value (id of a table)

In the Stored procedure i'd like to get this parameter to do something like that :

CREATE OR REPLACE PROCEDURE MyPrc
(ListOfPoint in ?????? ) AS

BEGIN SELECT col1,col2 FROM MyTable WHERE Col3 in (ListOfPoint)

END; Do you have an idea??

I tried this :

• in crystal, convert the list of parameter ListofPoint into string by a join to get a "1,2,3"
• in the stored procedure declare the ListOfPoint into varchar2 but the select do not work because Col3 is a number