555 User Defined Resource Error
The request could not be processed because an error occurred whilst attempting to evaluate the SQL statement associated with this resource. Please check the SQL statement is correctly formed and executes without error. SQL Error Code: ORA-22902: CURSOR expression not allowed , Error Message: {2}.
I get this error on my local Apex (Apex 19.1 with ORDS 18.4) and also on ATP Free tier (Apex 19.2 with ORDS 19.4) when using this query as my REST ORDS Handler query:
select d.deptno
,d.dname
,d.loc
,cursor (select e.empno
, e.ename
, e.sal
from emp e
where e.deptno = d.deptno)
from dept d
Apparently this was filed as a bug for Apex 18.1 (bug 28298260) and fixed in patch 28128115. So, is it back as a bug?