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!

p_url_mapping_pattern not working with ords 22.4 or 23.1 but works with 22.2

chakmasMay 9 2023

I am installing ORDS to replace OracleWeb/mod_plsql.

I have installed ords successfully. However when I try to create a mapping pattern it does not work for versions 22.4 or 23.1.

But it works perfectly with ORDS 22.2.

For example,

I have installed ORDS 22.2.

Then I enabled a schema (along with p_url_mapping_pattern) as below:

declare
pragma autonomous_transaction;
begin
ords.enable_schema(p_enabled=>true,
p_schema=>'WEB_USER',
p_url_mapping_type=>'BASE_PATH',
p_url_mapping_pattern=>'csweb',
p_auto_rest_auth=> false);

commit;
end;

Now if I try to my url like :

http:/172.1.1.0:8080/ords/csweb/myhtml. It works.

But if I do the same steps with ORDS 22.4 or 23.1, it does not recognize "csweb".

Is there something I am missing when using latest versions. Only because of this I am having to go with ORDS 22.2 although I want to use latest version.

Thanks in advance.

Comments
Post Details
Added on May 9 2023
2 comments
497 views