Error ORA-22902: CURSOR expression not allowed , when execute query from database actions
Hi, I'm running ords 21.4
Starting today, if I execute a query including cursor expression from database actions sql-developer (web), I get an error: ORA-22902: CURSOR expression not allowed
ORA-22902: CURSOR expression not allowed
If I run it from sql developer client (windows), it runs ok.
Example query:
select 'A' as head, cursor (select 'B' as val1, 'C' as val2 from dual) AS LIST from dual ;
I swear this used to work, I had it in a rest handler query, and it was working fine.