Hmm, this weird. I re-enabled the Embedded Procedural Gateway on port 8081, and went to the websheet with this URL:-
I then clicked on the button marked "Login", which gave me the login box, with this URL :-
I then changed the port to 8080, and was able to get the login box up, via ORDS.
So ... clicking on the login button does a redirect, and somewhere along the line we end up with an invalid character.
Enabling debug.printDebugToScreen gives me :-
mapped request using: BasePathMapper [basePath=/xe/] to: PLSQL:xe Choosing: oracle.dbtools.apex.ModApex as current candidate with score: PLSQLDispatchScore Using Procedure:f
oracle.dbtools.http.errors.InternalServerException: oracle.dbtools.common.util.URIs$IllegalURIException: The URI is not well-formed, reason: Illegal character in query at position: 84
Caused by: oracle.dbtools.common.util.URIs$IllegalURIException: The URI is not well-formed, reason: Illegal character in query at position: 84
Caused by: java.net.URISyntaxException: Illegal character in query at index 84: f?p=4900:101:13533674099222::NO::WS_APP_ID,P900_ID:102,&p_lang=en&p_territory=UNITED KINGDOM
at java.net.URI$Parser.fail(Unknown Source)
So the query is
and index 84 must be " " - I presume Java starts counting from 0.
When I copied the URL from EPG, the territory was UNITED%20KINGDOM, and on my desktop, it is AMERICA
Is this an escaping bug with ORDS?
By the way, Kris Rice says its OK to use ORDS with Oracle XE in his 2013 post about ORDS and supported app servers
Andrzej Raczkowski7 Nov 2013
Is this means that for commercial projects to be able to legally use APEX Listener I have to buy Oracle database?
I can't use APEX Listener with free Oracle Database Express Edition for commercial projects??
Kris Rice 7 Nov 2013
You can use it all you like. However , you need DB support to call oracle support.