create or replace procedure ProcedureName (Parametername in String) as

begin

Open Cursor for

SELECT * FROM tablename WHERE tablename.column IN
(parametername);

end;
----------------------------------------------------------------------
In the above example of stored procedure the paramter value I ma sending is like 24,36,54,68 and the column datatype in database is number.

So when I make parameter as string it will send it as '24,36,54' with quotes. Am i right? If I hardcode the parametervalue in the stored procedure it works fine but while passing it gives error.

The otherway round as you told to parameter as Varchar2. I also tried that but doesn't work.

Please help me.

Thank you
Shravan