In the emp table I have a column departments that saves a colon separated list of department ids e.g. "30:10".
In the interactive grid I want to use a popup lov to edit this column. The setting multiple values is set to yes.
When trying to save I get the following error:
Ajax call returned server error ORA-01722: invalid number for .
I have created a demo application:
https://apex.oracle.com/pls/apex/maisel/r/popup-lov-demo/2
The popup lov sql looks like this:
select dname d,deptno r from EBA_DEMO_IG_DEPT
I could use the shuttle item but in my real application the list of values has a lot of values and the shuttle is not very handy in this case.