HomeOracleOracle Error PLS-00714: supertypes’s AUTHID is DEFINER but supertype and subtype are not in same schema

Oracle Error PLS-00714: supertypes’s AUTHID is DEFINER but supertype and subtype are not in same schema

Oracle Error Message

PLS-00714: supertypes’s AUTHID is DEFINER but supertype and subtype are not in same schema

Reason for the Error

The supertype’s AUTHID is DEFINER, but the supertype and subtype are defined in different schemas. SQL statements executed in dynamically dispatched methods can potentially pick up different values from database tables in the two schemas.

Solution

Create the subtype in the same schema as the supertype.

Share:

Leave a Reply

You May Also Like

Oracle Error Message CLSGN-32767: Internal error. Reason for the Error An unexpected error occurred. Solution Examine the message(s) that accompany...
Oracle Error Message CLSGN-00211: OCR batch operation failed. string Reason for the Error Setting a set of Oracle Cluster Registry...
Oracle Error Message CLSGN-00210: failed to get value for OCR key “string”. string Reason for the Error It was not...