Database Actions (SQL Developer Web) (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center