Skip to:
Not sure if the problem is in Hibernate or Oracle 23c. Copying from a conversation with Loic:
A minimal reproducer is:
producing ORA-00904: "AGGREGATE"."THEINT"."NUMBER": invalid identifier
ORA-00904: "AGGREGATE"."THEINT"."NUMBER": invalid identifier
The fact is that you're using Oracle SQL dot notation that requires an alias (ideal usage being DML).
So to make your code work, you'd need to use the JSON_VALUE() function instead such as:
Not sure if the problem is in Hibernate or Oracle 23c. Copying from a conversation with Loic:
A minimal reproducer is:
producing
ORA-00904: "AGGREGATE"."THEINT"."NUMBER": invalid identifierThe fact is that you're using Oracle SQL dot notation that requires an alias (ideal usage being DML).
So to make your code work, you'd need to use the JSON_VALUE() function instead such as: