Database Error Messages

ORA-01796

this operator cannot be used with lists

Cause

A relational operator was not allowed in this context. When comparing lists, use only an operator that tests for equivalence, such as =, !=, or IN.


Action

Rephrase the query so that it only compares lists for equivalence. For example, the following clause is invalid:

WHERE (A,B) > ((C,D), (E,F))

It may be necessary to compare individual columns separately. For example, to see if A and B are respectively greater than C and D, use WHERE A>B AND C>D instead of WHERE (A,B)>(C,D).