In this post, you’ll learn more about the Oracle ErrorPLS-00581: inheritance is not supported for opaque types with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
PLS-00581: inheritance is not supported for opaque types
Reason for the Error PLS-00581: inheritance is not supported for opaque types
An attempt was made to declare an opaque type with a supertype.
How to fix the Error PLS-00581: inheritance is not supported for opaque types ?
You can fix this error in Oracle by following the below steps
Remove the supertype specification.