Hi,
I was developing some rest services. Had some queries with cursor expression working.
Now starting today, when I issue any query including the cursor expression, it fails with ORA-22902
If I issue it from sql developer (windows client) it works. But if I go to ords database actions and issue it from sql-developer web, it fails.
Any clue? I'm pretty sure it worked yesterday!
Any simple cursor query like this fails:
select 'A' as test, cursor (select * from any_small_table) from dual;