Oracle 26ai

ORA-08720

Error Message

A subquery with ALL or ANY operator is not supported.

Cause

The following cases are not supported:

col1 op ANY (subquery) Where "op" is any supported operator except '=' or '!='
col1 op ALL (subquery) Where "op" is any supported operator except '!='
col1+5 != ALL (subquery) Expressions "col1+5" are not supported

Action

Rewrite the SQL assertion definition without the ANY or ALL operator.