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

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

Cause: 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.

Action: Create the subtype in the same schema as the supertype.

No comments:

Post a Comment