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

NNL-00907: NOT ALLOWED responses sent: number

1 Answers  


ORA-12988: cannot drop column from table owned by SYS

2 Answers   eSys,


ORA-29856: error occurred in the execution of ODCIINDEXDROP routine

2 Answers  


ORA-16601: site contains required resources that are disabled

1 Answers  


NCR-04013: NCRR: Insufficient authorization

1 Answers  






ORA-01052: required destination LOG_ARCHIVE_DUPLEX_DEST is not specified

1 Answers  


PLS-00536: Navigation through REF variables is not supported in PL/SQL.

1 Answers  


ORA-02215: duplicate tablespace name clause

1 Answers  


SQL*Loader-00820: cannot create where clause with range for table string

1 Answers  


DRG-11509: value expected on line string

1 Answers  


PCC-02384: Missing array length specifier

1 Answers  


ORA-02777: Stat failed on log directory

1 Answers  


Categories