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

Translate this page

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.

User Posts for PLS-00366

Be the first to post a message...

Post your own questions, answers and tips for PLS-00366

No registration required

CAPTCHA Image New word