Database Error Messages

Release
toggle
  • 23ai
Updated
Jun 24, 2024

JZN-00280

Invalid comparison to root path in predicate

Cause

A predicate used a disallowed comparison operator for a path beginning with root ('$'). Root paths cannot be used with 'in' statements and cannot be used with string matching operators such as 'like', 'starts with', 'has substring', and regular expression patterns.


Action

Use a relative path expression beginning with '@', or use a simple equality or inequality comparison.