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?