Interested to Buy Any Domain ? << Click Here >> for more details...
PLS-00412: list of values not allowed as argument to this
function or procedure
- 1 Answers
- 5085 Views
- I also Faced
- E-Mail Answers
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 |
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-01030: SELECT ... INTO variable does not exist
ORA-32806: value for string is too long, maximum length is string
ORA-39601: Hash key is required.
ORA-29349: tablespace 'string' already exists
ORA-16127: stalled waiting for additional transactions to be applied
ORA-06306: IPA: Message write length error
ORA-27300: OS system dependent operation:string failed with status: string
ORA-00703: maximum number of row cache instance locks exceeded
ORA-39302: schema clone operation failed
ORA-03242: Tablespace migration retried 500 times
ORA-01250: Error string occurred during termination of file header access
Oracle Errors 
