want to pass multiple values into a procedure

[vbaskar]

since the number of parameters is not static u can do this by sending the parameters in to an varchar2 field.
variablein = '14,48,56,42,31,12'

replace the where clause with the variable...