PLS-00218
a variable declared NOT NULL must have an initialization assignment
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).