I read your message. here is my stored procedure
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