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-01563: rollback segment is PUBLIC, need to use the keyword PUBLIC

1 Answers  


PCC-02410: Expecting an expression of some Collection type.

1 Answers  


ORA-13225: specified index table name is too long for a spatial index

1 Answers  


ORA-33334: (DSSEXIST04) Analytic workspace string is not attached.

1 Answers  


DRG-11212: procedure filter procedure name contains a semicolon

1 Answers  






ORA-36968: (XSRELTBL11) workspace object must be a relation.

1 Answers  


SQL*Loader-00435: invalid constant value string for nested table column string

1 Answers  


ORA-02314: illegal use of type constructor

1 Answers  


ORA-19688: control file autobackup format(string) for string does not have %F

1 Answers  


ORA-03277: invalid SIZE specified

1 Answers  


ORA-19717: for non-OMF search the pattern must be specified

1 Answers  


ORA-26509: null materialized view control structure

1 Answers  


Categories