My Oracle Support Banner

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 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
these errors:


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

Unable to capture the XML file after using the exporter tool.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.