** Note sorry for the repeat posts 10hrs ago, every time I hit post it said there was an error yesterday, I've deleted them all now, I still don't know if this is a bug or something I've done wrong **
Hello,
I hope someone can help
- I've created a popup LOV in an IG using the same method as we have used for shuttle lists so the grid query does a listagg of colon separated child values
- I created a shared component for the LOV, displays a varchar2 returns id as a number
- I display this in my grid as a popup LOV with multiple select separated by colons.
- When I run the page I get the following error.
ora_sqlerrm: ORA-01722: invalid number ORA-06512: at
"APEX_200100.WWV_FLOW_DISP_PAGE_PLUGS", line 1183 ORA-06512: at
"APEX_200100.WWV_FLOW_DISP_PAGE_PLUGS", line 2121 ORA-06512: at
"APEX_200100.WWV_FLOW_INTERACTIVE_GRID", line 4758 ORA-06512: at
"APEX_200100.WWV_FLOW_INTERACTIVE_GRID", line 3957 ORA-06512: at
"APEX_200100.WWV_FLOW_EXEC", line 2684
etc. etc.
or Ajax call returned server error ORA-01722: invalid number for .
- I had this same error in shuttle lists and the resolution was to to_char the return value
- to_char the return value in the list I'm using for the LOV resolves the above error however now when we select one value, it displays the display value, select more than one, it displays the display values comma separated but when you save the values and refresh the page any record with more than one value displays the colon separated id values rather than the display values. Its defaulting to the "Display Extra Values" which is showing them because it cant resolve the ids I guess.
https://apex.oracle.com/pls/apex/scstest/r/140245/basic-editing
log on as demo / demo1234
I have taken the basic editing page and made the dept field multi select to demonstrate the issue
https://apex.oracle.com/pls/apex/scstest/r/140245/basic-editing-copy
this is a copy of the page but using an LOV without the to_char of the ID, will give the ORA-01722
Thanks for
reading / thinking