This content has been marked as final. Show 1 reply
This is the infamous "Varring IN list" problem.
It is an SQL problem, not an APEX problem.
Take a look at this:
You'll also need to remove the single quotes from the string... I haven't tried the below..
with data as ( select trim( substr (txt, instr (txt, ',', 1, level ) + 1, instr (txt, ',', 1, level+1) - instr (txt, ',', 1, level) -1 ) ) as token from (select ','|| REPLACE( :txt, '''', '' ) ||',' txt from dual) connect by level <= length( REPLACE(:txt,'''','') )-length(replace( REPLACE(:txt, '''', '') ,',',''))+1 ) select * from all_users where username in (select * from data)