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 |
NNL-00287: Cache flush occurs in string
ORA-22615: attribute is not a collection
PROT-00005: Clusterware is not running properly
RMAN-06562: available space of number kb needed to avoid reading the backup set multiple times
ORA-02495: cannot resize file string, tablespace string is read only
ORA-06109: NETTCP: message receive failure
RMAN-06726: could not locate archivelog string
ORA-02461: Inappropriate use of the INDEX option
ORA-33450: (ESDREAD05) Discarding compiled code for workspace object because number now has more or fewer dimensions than it had when the code was compiled.
ORA-16701: generic resource guard request failed
ORA-02201: sequence not allowed here
ORA-31111: table string cannot be hierarchically enabled