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-09802: Conversion of binary label to string failed.

1 Answers  


ORA-02262: ORA-string occurs while type-checking column default value expression

1 Answers  


ORA-02840: Open of log file by client failed

1 Answers  


ORA-28045: SSL authentication between database and OID failed

1 Answers  


DRG-11531: start token not found on line string

1 Answers  






NNL-00263: Request forwarding is now enabled

1 Answers  


RMAN-06487: changed proxy copy expired

1 Answers  


ORA-07268: szguns: getpwuid error.

1 Answers  


NID-00002: Parse error: string

1 Answers  


ORA-07650: sigunc: $GETJPIW failure

1 Answers  


ORA-01924: role 'string' not granted or does not exist

1 Answers  


ORA-22309: attribute with name "string" already exists

1 Answers  


Categories