Database Error Messages

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

ORA-40796

invalid comparison operation involving JSON type value

Cause

An attempt was made to perform a comparison against a JSON type value.


Action

Add a JSON trailing type cast function to compare the JSON type value against a scalar value. Use JSON_EQUAL to compare two JSON type values.