My Oracle Support Banner

Private Synonym for an Object Owned by Another Schema Returns 404 ERROR (Doc ID 1662939.1)

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:

http://domain/test/testme works.

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.


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.