Skip to Main Content

Check if value is in list manager

BaonergesDec 29 2016 — edited Dec 30 2016

Hello Everyone,

I am trying to run a query using my list manager as the parameter. "P2_DELH_NO" is the name of my List Manager which I add numbers to. I then have a table which updates based on the values in the List Manager as follows:

select ITEM_CODE_DEL,DELL_DESC,DELL_QTY1_DEL,UNIT_CODE_DEF from dell where delh_no in :P2_DELH_NO

It only works when there is a single value in the list. As soon as I have more values in the list, it gives me "report error: ORA-01722: invalid number" because it sees something like this "118096:118097:118100:118102:118103"

I have tried switching the colons with commas, adding brackets, but I can't get it to see it as a list. How would I change my query or other items to do this?

Thank you.

This post has been answered by Pranav.shah on Dec 29 2016
Jump to Answer
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Jan 27 2017
Added on Dec 29 2016