Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-26535: %ud byte row cache insufficient for table with rowsize=number

1 Answers  


ORA-13110: cannot drop topology with associated topo_geometry tables

1 Answers  


LSX-00234: invalid decimal "~S"

1 Answers  


RMAN-06725: database not open: sort area size too small

1 Answers  


ORA-29663: Unable to find a method that matches one or more of the functions

1 Answers  






ORA-00603: ORACLE server session terminated by fatal error

2 Answers  


ORA-13754: "SQL Tuning Set" "string" does not exist.

2 Answers  


ORA-30035: Undo tablespace cannot be specified as default temporary tablespace

1 Answers  


RMAN-03015: error occurred in stored script string

1 Answers  


ORA-26076: cannot set or reset value after direct path structure is allocated

0 Answers  


O2F-00312: Illegal or missing type version string

1 Answers  


RMAN-06541: tablespace string will be included in future whole database backups

1 Answers  






Categories