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



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

Answer / guest

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 ...)

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

SQL*Loader-00913: Error fetching results of select statement (upi): [number]

1 Answers  


ORA-22287: invalid or modified directory occurred during string operation

1 Answers  


ORA-19590: conversation already active

1 Answers  


ORA-29850: invalid option for creation of domain indexes

1 Answers  


ORA-07218: slkhst: could not perform host operation

1 Answers  






ORA-06321: IPA: Cannot reach the remote side

1 Answers  


PLS-00212: could not obtain enough memory to compile CASE statement

1 Answers  


ORA-15070: maximum number of files string exceeded in diskgroup "string"

1 Answers  


ORA-38418: ADT associated with the attribute set string does not exist

1 Answers  


ORA-14309: Total count of list values exceeds maximum allowed

1 Answers  


NID-00140: Specified database name string does not match previous name used string

1 Answers  


SQL*Loader-00504: Error skipping records in file (string)

1 Answers  


Categories