PLS-00218: a variable declared NOT NULL must have an
initialization assignment



PLS-00218: a variable declared NOT NULL must have an initialization assignment..

Answer / guest

Cause: In general, variables that have no initialization
clause in their declaration are automatically initialized to
NULL. This is illogical for NOT NULL variables; therefore,
an initialization clause is required.

Action: Add an initialization clause to the variable
declaration. If the initilization is too complicated for the
syntax, one can add a function call (in a later release).

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-38474: attribute set may not have attributes of TABLE COLLECTION type.

1 Answers  


ORA-14256: invalid resulting partition description(s)

1 Answers  


SQL*Loader-00412: More columns specified for table string than the maximum (number)

1 Answers  


NZE-29004: Callback Failure

1 Answers  


PCC-02439: FOR clause not allowed in this COLLECTION statement

1 Answers  






RMAN-10034: unhandled exception during execution of job step number, error unknown

1 Answers  


PLS-00636: overriding method requires OVERRIDING keyword

1 Answers  


ORA-30729: maximum number of columns exceeded

1 Answers  


NNL-00541: set|show trace_level [<level>] [<server_list>] : set|show the server's tracing level

1 Answers  


ORA-24430: Null values for sqltext and key were specified.

1 Answers  


ORA-25210: invalid value for RELATIVE_MSGID, no message in queue with that msgid

1 Answers  


ORA-27035: logical block size is invalid

1 Answers  


Categories