OCI-08720
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.