How to fix the Oracle error PLS-00607: SQLJ Object Types can have only SQLJ Types as its supertype or subtype?

In this post, you’ll learn more about the Oracle ErrorPLS-00607: SQLJ Object Types can have only SQLJ Types as its supertype or subtype with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PLS-00607: SQLJ Object Types can have only SQLJ Types as its supertype or subtype

Reason for the Error PLS-00607: SQLJ Object Types can have only SQLJ Types as its supertype or subtype

You were trying to create a SQLJ Object Type under a non-SQLJ Object Type.

How to fix the Error PLS-00607: SQLJ Object Types can have only SQLJ Types as its supertype or subtype ?

You can fix this error in Oracle by following the below steps

Recreate the type as a SQLJ Object Type.