Have Multiple Successive Dot Characters Receive Error 400 Bad Request

(Doc ID 2349074.1)

Last updated on JANUARY 19, 2018

Applies to:

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

Goal

If there is multiple successive dot characters in the browser URL header, receive Error 400 Bad Request: The request path contains illegal characters

 
Example : http://seelmwbikjo.dsit.sncf.fr:8443/ords/mymap/mypath/abc/6109276T2014-12-22-13.29.45.963023301114_E.....pdf

Using ORDS RESTful web service and running in standalone mode using the built-in Jetty web server.

Below the web service created:


BEGIN
ORDS.define_service(
p_module_name => 'mypath/',
p_base_path => 'mypath/',
p_pattern => 'abc/:fname',
p_method => 'GET',
p_source_type => ORDS.source_type_media,
p_source => 'SELECT ''application/pdf'' CONTENT_TYPE, SYSADM.append_chunk_pj(ATTACHSYSFILENAME) FROM mytable WHERE ATTACHSYSFILENAME = :fname',
p_items_per_page => 0);
COMMIT;
END;
/

 

Solution

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