Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-22902 cursor expression not allowed.

juliojgsMar 29 2023

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;

This post has been answered by thatJeffSmith-Oracle on Apr 3 2023
Jump to Answer
Comments
Post Details
Added on Mar 29 2023
11 comments
931 views