APEX

Apex 18.2

Hi,

I have an interactive report based on a PL/SQL function with the following code:

return q'~
select EMPNO,
       ENAME,
       JOB,
       MGR,
       HIREDATE,
       SAL,
       COMM,
       DEPTNO
  from EMP
 where DEPTNO IN (~'||:P2_DEPTNO||')';

:P2_DEPTNO is a popUp Lov that allow multiple values. And it's based on:

select dname, deptno from emp;

When I validate the function it shows,

ORA-20999: Parsing returned query results in "ORA-20999: Failed to parse SQL query! <p>ORA-06550: line 13, column 6: ORA-00936: missing expression</p>".