Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Allowing .xml in uri template

Jon FinkeAug 12 2022

Had to provide an RSS feed for a project - put together a view that generates an XML document, and set up a template with a multimedia handler; works fine. Using ORDS 21.1.3.r1531102.
The RSS page checks out ok (w3C validator), but one of my target users is the campus cable TV system, which ran read an RSS feed - BUT - needs the URL to end in .xml. When I try to add that to the template "rss" => "rss.xml", it complains about illegal characters.

This post has been answered by Jon Finke on Aug 16 2022
Jump to Answer

Comments

Hi Volker,

can you run the login page in debug mode (LEVEL9) to see what happens? I first thought this could be bug #14798940 but in that case the problem would have gone away after saving the authentication scheme.

Regards,
Christian
99770
Ho to do Level 9 Debug?
Hi Volker,

the app's URL will look a bit like this:

http://host:port/apex/f?p=app:page:session::NO::

Change NO to LEVEL9. Before 4.2, you could only say YES, which is level 4, or NO. LEVEL9 gives the most detailed output.

Regards,
Christian
99770
error:ORA-24247: network access denied by access control list (ACL), backtrace:ORA-06512: at "SYS.DBMS_LDAP_API_FFI", line 25 ORA-06512: at "SYS.DBMS_LDAP", line 48 ORA-06512: at "APEX_040200.WWV_FLOW_CUSTOM_AUTH_LDAP", line 45
Hi,

the post-installation steps described here

http://docs.oracle.com/cd/E37097_01/doc/install.42/e35123/otn_install.htm#BEHHJJIH

to configure the ACL for APEX_040200 seem to be missing.

Regards,
Christian
99770
Hi Christian,

many thanks to you. Now it works.
1 - 6

Post Details

Added on Aug 12 2022
3 comments
109 views