Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

DRG-12509: length of the stop word string exceeded the limit of string bytes

1 Answers  


ORA-16401: archivelog rejected by RFS

1 Answers  


ORA-16037: user requested cancel of managed recovery operation

1 Answers  


ORA-09213: slgfn: error fabricating file name

1 Answers  


LSX-00018: invalid schema context

1 Answers  






ORA-27011: skgfrd: cannot read from file opened for write

1 Answers  


PLS-00511: a record may not contain a PL/SQL table of records

1 Answers  


LPX-00268: invalid access method ~1d, must be 0 to ~2d

1 Answers  


ORA-38491: could not evaluate subexpression for rowid "string"

1 Answers  


ORA-13417: null or invalid layerNumber for get functions

1 Answers  


ORA-02076: sequence not co-located with updated table or long column

1 Answers  


PLS-00171: duplicate dedicated AGENT specification in subprogram expression

1 Answers  






Categories