PLS-00412: list of values not allowed as argument to this function or procedure

Cause: A parenthesized list of values separated by commas (that is, an aggregate) was used in the wrong context. For example, the following usage is invalid: 

WHERE (col1, col2) > (SELECT col3, col4 FROM my_table ...) 

However, an equal sign can take a list of values and a subquery as left- and right-hand-side arguments, respectively. So, the following usage is valid: 

WHERE (col1, col2) = (SELECT col3, col4 FROM my_table ...)

Action: Rewrite the expression. For example, the clause: 

WHERE (col1, col2) > (SELECT col3, col4 FROM my_table ...) 

can be rewritten as: 

WHERE col1 > (SELECT col3 FROM my_table ...) AND col2 > (SELECT col4 FROM my_table ...)

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/