Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, prasanna.

Asked: July 08, 2022 - 1:12 pm UTC

Last updated: August 31, 2022 - 5:49 am UTC

Version: 22

Viewed 10K+ times! This question is

You Asked

Hi Tom

Currently we use APEX 21.4 with ORDS 21 deployed using Tomcat 9.

Tried to upgrade ORDS to 22.2 and I see its all new compared to old versions. I did a fresh install and configured the pools. All worked fine. But with one issue which I struck up.

Previously, we use https://server/apex (I renamed the ords.war to apex.war and deployed).

I did the same here after 22.2 ords install.

It works with https://server/ords but not working with https://server/apex

When I use this context root https://server/apex I get

The procedure named apex could not be accessed, it may not be declared, or the user executing this request may not have been granted execute privilege on the procedure, or a function specified by security.requestValidationFunction configuration property has prevented access. Check the spelling of the procedure, check that the execute privilege has been granted to the caller and check the configured security.requestValidationFunction function.

If I use https://server/ords, it works.

I checked the tomcat logs, there is no entry for apex.war deployment. But when I checked tomcathome/webapps, I see apex folder.

Any help ?

Thanks
Prasanna

and Connor said...

ORDS 22 has a different configuration strategy. You do not rename the war file any more.

Check Ch 3 of the config guide

https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/22.2/ordig/configuring-additional-databases.html#GUID-C8D8F633-2777-41C5-BC4E-CC1F222CCDC0

Things are totally different in ORDS 22

Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Jane Essig, August 29, 2022 - 4:47 pm UTC

Our applications still use "pls" in their URLs dating back to pre-ORDS dads.conf days. Is there a way to continue to use a pls.war file instead of having to have all the applications change their code?
Connor McDonald
August 30, 2022 - 1:35 am UTC

Are you using ORDS standalone mode or under Tomcat (or similar) ?

ORDS 22

Prasanna, August 30, 2022 - 12:11 pm UTC

Yes.. You can use same pls in your url. Deply the war as pls.war and remove the line from the below config file..

ords/conf/databases/default/pool.xml

Remove the below line from pool.xml

<entry key="security.requestValidationFunction">wwv_flow_epg_include_modules.authorize</entry>

It started working for me afterwards.
Connor McDonald
August 31, 2022 - 5:49 am UTC

thanks for stopping by

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library