MD_META is Marked Invalid After Creating the SQL*Developer Repository
(Doc ID 461545.1)
Last updated on MAY 11, 2022
Applies to:Oracle Migration Workbench - Version 10.2.0.3 and later
Oracle SQL Developer - Version 3.0 to 3.0 [Release 3]
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
When creating the repository for SQL*Developer the package MD_META can be marked invalid and will not compile. SQL*Developer will display this object marked as invalid. This package is wrapped and
so there is no way to see what line is causing the error. Recompiling the package will result in
Error(27,2): PL/SQL: SQL Statement ignored
Error(30,23): PL/SQL: ORA-00904: : invalid identifier
Problems from this vary and are unpredictable.
Here are a couple of examples
(1) Using SQL*Server
When trying to collect metadata information from SQL*Server the following errors occur -
ORA-04063: package body "xxx.MD_META" has errors
ORA-06508: PL/SQL: could not find program unit being called: "xxx.MD_META"
ORA-06512: at "xxx.MD_PROJECTS_TRG", line 3
ORA-04088: error during execution of trigger 'xxx.MD_PROJECTS_TRG'
(2) Using Access
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document