OCI-40467
Cannot find a JSON-enabled Full-Text Index or an In-Memory Full-Text column to evaluate the JSON_TEXTCONTAINS predicate.
Cause
The JSON_TEXTCONTAINS condition could not be used because the JSON data was not indexed with either a JSON search index, or a JSON-enabled CONTEXT index, nor was it part of an In-Memory Full-Text column.
Action
Create a JSON search index, or create a JSON-enabled CONTEXT index, or use an In-Memory Full Text column to use the JSON_TEXTCONTAINS condition.