PL/SQL (MOSC)

MOSC Banner

DBMS_METADATA.GET_DDL not working within trigger after upgrade from 12c to 19c

edited May 14, 2020 1:08PM in PL/SQL (MOSC) 7 commentsAnswered ✓

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"

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center