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

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

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).

No comments:

Post a Comment