How to fix the Oracle error PLS-00722: supertypes’s AUTHID is different than subtype’s AUTHID?

In this post, you’ll learn more about the Oracle ErrorPLS-00722: supertypes’s AUTHID is different than subtype’s AUTHID with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PLS-00722: supertypes’s AUTHID is different than subtype’s AUTHID

Reason for the Error PLS-00722: supertypes’s AUTHID is different than subtype’s AUTHID

The subtype’s’s AUTHID must be same as the supertype’s AUTHID.

How to fix the Error PLS-00722: supertypes’s AUTHID is different than subtype’s AUTHID ?

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

Create the subtype with AUTHID of its supertype or do not specify AUTHID for subtype.