Database Error Messages

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.