Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

ORA-40561

invalid path 'string' in JSON_TABLE NESTED PATH clause

Cause

The JSON_TABLE expression contained a NESTED PATH clause with an invalid path expression. For example, '$' is an invalid path because it selects the current context instead of accessing the nested data.


Action

Correct the NESTED PATH expression or remove the NESTED PATH clause.