Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

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.