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) lamp;gt; (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) lamp;gt; (SELECT col3, col4 FROM my_table ...) can be rewritten as WHERE col1 lamp;gt; (SELECT col3 FROM my_table ...) AND col2 lamp;gt; (SELECT col4 FROM my_table ...)
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) lamp;gt; (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) lamp;gt; (SELECT col3, col4 FROM my_table ...) can be rewritten as WHERE col1 lamp;gt; (SELECT col3 FROM my_table ...) AND col2 lamp;gt; (SELECT col4 FROM my_table ...)
No comments:
Post a Comment