Classic report issue with multiple inputs with IN statement

Question

I am trying to refresh a report with dynamic action. And get the following errors:

{'dialogue': {'uv': true, 'line': [{'V': "failure of Widget}]}} ORA-20876: stop the engine of the APEX. classic_report"}]}}

I think its an issue with string which can't take and ST.ID IN (:P11_ROW_PK) in sql query.

Please suggest a workaround for the same.

Answer 1

where REGEXP_LIKE(CUSTOMER_ID, '^('|| REPLACE(:P4_SEARCH,',','|') ||')$') Above code will act same as APEX_STRING only if you are using lower version Apex