Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How do I pass a list for the IN operator in a variable

634676Mar 30 2010 — edited Mar 30 2010
I have a procedure which receives for one of it's IN variables (var1) a comma delimited list of strings. I output the value of var1 to a file so I know it is receiving the full string as...

'700 Number Calls','800 Number Calls','900 Number Calls','Customer Service Calls','Directory Assistance','Emergency/911 Calls','International Calls','Standard Phone Calls','Voicemail'

When manually typing a query using "IN ('700 Number Calls','800 Number Calls',...'Standard Phone Calls','Voicemail')" the query returns three rows

When the procedure does a Select statement using "IN (var1)" no rows are returned. How can I pass the comma denoted list for the IN operator within a single variable?
This post has been answered by Tubby on Mar 30 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 27 2010
Added on Mar 30 2010
2 comments
1,213 views