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.

Symptoms

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.

 

Changes

 Moved from Oracle HTTP Server (OHS) / mod_plsql to ORDS / APEX Listener.

Cause

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