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.

Post Details
Added on Dec 29 2016