|ORA-01796:||this operator cannot be used with lists|
|Cause:||A relational operator is 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).