Hi, I have a select query(Select username from users where userids in ($P{p_user_id})). This query returns rows depending upon the value passed to the paramater (p_user_id) as a prompt where I enter the user ids. As long as I'm entering single user id (for eg. u101), its returning me the correct username. But when i enter multiple user ids (like u101,u102) in the prompt, its not retruning any data. I also tried giving the user ids inside single quotes (like 'u101','u102') in the prompt but it didn't work. Pls let me know how should i format the input parameter(user ids) so that i get the user names. thanks in advance...