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

AMD-00114: PROCEDURE string, internal error

1 Answers  


ORA-24805: LOB type mismatch

1 Answers  


PLS-00388: undefined column 'string' in subquery

1 Answers  


ORA-19808: recovery destination parameter mismatch

1 Answers  


ORA-09263: spini: error initializing process

1 Answers  


ORA-14631: the partition bounds do not match the subpartition bounds of the partition

1 Answers  


LPX-00257: invalid children specification in element declaration

1 Answers  


ORA-32341: The EXPLAIN_MVIEW facility failed to explain the materialized view "string"."string"

1 Answers  


RMAN-06202: Deleted string EXPIRED objects

1 Answers  


LSX-00157: "~S" is abstract and cannot be used in an instance document

1 Answers  


ORA-24022: the specified parameters has no effect on the queue

1 Answers  


PLS-00920: parameter plsql_native_library_dir is not set

1 Answers  


Categories