Quickly resolve Oracle Database errors with Oracle Doctor

Oracle Database Error PLS-00366

PLS-00366 subtype of a NOT NULL type must also be NOT NULL

Cause

After a subtype was defined as NOT NULL, it was used as the base type for another subtype defined as NULL. That is not allowed. For example, the code might look like DECLARE SUBTYPE Weekday IS INTEGER NOT NULL; SUBTYPE Weekend IS Weekday NULL; -- illegal instead of DECLARE SUBTYPE Weekday IS INTEGER NOT NULL; SUBTYPE Weekend IS Weekday;

Action

Revise the subtype definitions to eliminate the conflict.

PLS-00366 Comments

No comments yet

Submit comments and questions for PLS-00366

No registration required

CAPTCHA Image New word