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

ORA-30193: reserved for future use

1 Answers  


ORA-01249: archiving not allowed in a clone database

1 Answers  


QSM-01572: equivalence, string, and query have different joins between tables, string

1 Answers  


ORA-23319: parameter value string is not appropriate

1 Answers  


ORA-24089: AQ Agent string already exists

1 Answers  






TNS-00028: INTCTL: Could not resolve Connection Manager's name/address

1 Answers  


ORA-01079: ORACLE database was not properly created, operation aborted

1 Answers  


ORA-12481: effective label not within program unit clearance range

1 Answers  


PLS-00994: Cursor Variables cannot be declared as part of a package

1 Answers   CTS,


ORA-02339: invalid column specification

1 Answers  


ORA-07756: slemcf: fread failure

1 Answers  


ORA-14001: LOCAL clause contradicts previosly specified GLOBAL clause

1 Answers  


Categories