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 |
NCR-04008: NCRR: Procedure exists
RMAN-08109: channel string: restored block(s) from backup piece string
DRG-12212: error while dropping section string
SQL-02154: Invalid or unset data type for host variable in ANSI Dynamic
ORA-27052: unable to flush file data
ORA-23498: repgroups specified must have the same masters
PCC-00099: Length cannot be given for types ROWID, DATE, or MLSLABEL
ORA-13426: invalid window parameter for subset operation
ORA-28165: proxy 'string' may not specify password-protected role 'string' for client 'string'
ORA-08274: Out of memory for environment variable
QSM-01065: materialized view, string, cannot compute measure, string, in the query
RMAN-06173: no set newname command has been issued for datafile string when restore auxiliary