You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Enabling REST Data Services on ATP is failing

edited Apr 16, 2022 7:54AM in Autonomous Database 2 comments

Summary

ORA-06508: PL/SQL: could not find program unit being called: "ORDS_METADATA.ORDS"

Content

After months of development utilizing the REST data services on our Autonomous Transaction Processing database, RESTful Services is now blocked.  The processes that are calling the services are running fine, however I am unable to enable on a new table needed for an enhancement.  The error message is:

- ORA-04063: package body "ORDS_METADATA.ORDS" has errors
ORA-06508: PL/SQL: could not find program unit being called: "ORDS_METADATA.ORDS"
ORA-06512: at line 5

Working in Oracle SQL Developer and pulling up the RESTful Services Wizard returns this error on the first step.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!