My Oracle Support Banner

ORDS Cannot Handle "V" In Requests as There is a Public Synonym Named 'V' (Doc ID 2584063.1)

Last updated on SEPTEMBER 15, 2022

Applies to:

Oracle REST Data Services - Version 19.2 and later
Information in this document applies to any platform.

Symptoms

  

NOTE: The example(s) provided are based on the Oracle REST Services demo service and represents fictitious data. Any similarity to actual data, web sites and / or persons, living or dead, is purely coincidental and not intended in any manner.

 19.1 ORDS + Apache Tomcat/8.5.41


When performing a GET request with a V as filter, for example:
ords/demo_test/V
will result in ORA-20001: Path=V rejected

The problem is caused only when the following line is added in the code like :

 

When apex_util.set_security_group_id(l_workspace_id);  is removed, then it seems works fine using 'v'.

Cause

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
Symptoms
Cause
Solution


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