DBMS_METADATA.GET_DDL not working within trigger after upgrade from 12c to 19c
Hello,
I am using DDL triggers, e.g. "after create on database", to keep track of table creation/alteration/drops in my database. To this end I make use of DBMS_METADATA.GET_DDL within the trigger body to retrieve DDL of a created/altered/dropped table and save it to a backup table. The trigger is owned by a privileged user (select_catalog_role and all necessary sys privileges are granted). After upgrading from 12.2.0.1.0 Standard Edition to 19.0.0.0.0 Standard Edition GET_DDL keeps on failing with exception message ORA-31603: object "MY_TABLE" of type TABLE not found in schema "MY_SCHEMA"