[nivin]

Hey Gurus,

Can you help me to pass multi values into single parameter in plsql.

This is the scenario (a rough one ):

create procedure abcd(p_single IN Varchar(100))
select * from table_x
where col_1 IN(p_single)

for p_single I need to pass more than one string.

Could you please help me ...?

[Littlefoot]

A varying IN list ... check the article on Tom Kyte's blog, or search for another resources by yourself (now you know what to search for).