Private Synonym for an Object Owned by Another Schema Returns 404 ERROR
Last updated on JUNE 09, 2017
Applies to:Oracle REST Data Services - Version 2.0.5 and later
Information in this document applies to any platform.
Using Oracle REST Data Services (ORDS) / the Apex Listener 2.0.6.
Connecting via ORDS / the APEX Listener to a private schema (one with only synonyms and grants) is resulting in no records displayed when outputting query results. The private schema that has EXECUTE on a PL/SQL procedure and a synonym to the procedure that is owned by a different schema.
The same request runs without error when using the Oracle HTTP Server with mod_plsql as the web server.
Steps to Reproduce the issue:
1) Create private synonym in TEST for object owned by another schema:
So once the synonym is CREATED as a PUBLIC synonym by the SYSTEM user, it will work from then on. But will NOT work if initially created by the TEST schema.
Moved from Oracle HTTP Server (OHS) / mod_plsql to ORDS / APEX Listener.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms