PLS-00621: at least one operand in the COALESCE expression
must not be NULL



PLS-00621: at least one operand in the COALESCE expression must not be NULL..

Answer / guest

Cause: All the operands in the COALESCE expression are the
literal NULL.

Action: Change at least one operand in the COALESCE
expression to be non-NULL.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01326: compatability of 9.0 or greater required to build into the logstream

1 Answers  


ORA-08275: Environment variable unset

1 Answers  


SQL-02131: Runtime context in use

2 Answers  


RMAN-06423: requested limit of number exceeds vendor limit of number

1 Answers  


ORA-16771: Converting physical standby to primary failed in the failover operation.

1 Answers  






ORA-24422: error occurred while trying to destroy the Session Pool

1 Answers  


ORA-24327: need explicit attach before authenticating a user

1 Answers  


PLS-00993: Cursor Variables cannot be passed as RPC arguments or results

1 Answers  


PLS-00604: aggregate function is not allowed here

1 Answers  


ORA-32610: missing SINGLE REFERENCE or DIMENSION keyword in MODEL clause

1 Answers  


ORA-22896: cannot have both scope and referential constraint on REF column "string"

1 Answers  


TNS-04082: %s event string set to string.

1 Answers  


Categories