Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Problem migrating from MOD_PLSQL to ORDS (Apex 20.2, ORDS 20.3, Tomcat 8.5, XE 18)
Problem migrating from MOD_PLSQL to ORDS [message #685036] Tue, 12 October 2021 16:43 Go to next message
Messages: 1
Registered: October 2021
Junior Member
I have a a PL/SQL application I am trying to migrate to Application Express and ORDS on Tomcat. The PL/SQL application has packages that use the htp package to generate web pages.

I have APEX and ORDS installed and I can start ORDS through Tomcat. I just want to set things up so that a URL like localhost:8080/ords/gator/gator$session.Hello gets invoked to generate a web page just like it used to with MOD_PLSQL. I made sure the package compiles without errors and has a public procedure like:

But at the moment I get a 404 Not Found error when trying to access this simple page-generating procedure. What setup steps have I missed?

My setup (using SYS as SYSDBA)

--  Establish the container.

alter session set container=XEPDB1;

--  Drop the user if it already exists.

drop user GATOR cascade;

--  Create the user.

create user GATOR identified by gator
    default tablespace users quota unlimited on users;


alter user GATOR grant connect through ORDS_PUBLIC_USER;

--  Grant permissions.

grant create session to GATOR;
grant create sequence to GATOR;
grant create public synonym to GATOR;
grant create database link to GATOR;
grant create synonym to GATOR;
grant create trigger to GATOR;
grant create table to GATOR;
grant create role to GATOR;
grant create procedure to GATOR;
grant create materialized view to GATOR;
grant alter session to GATOR;
grant create view to GATOR;
grant create any DIRECTORY to GATOR;
grant drop any directory to GATOR;
then as (gator/gator@xepdb1)


		p_enabled		=> TRUE,
		p_schema		=> 'GATOR',
		p_url_mapping_type	=> 'BASE_PATH',
		p_url_mapping_pattern	=> 'gator',
		p_auto_rest_auth	=> FALSE

Re: Problem migrating from MOD_PLSQL to ORDS [message #685039 is a reply to message #685036] Wed, 13 October 2021 01:56 Go to previous message
John Watson
Messages: 8707
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum.

Does your ORDS defaults.xml file include
<entry key="security.requestValidationFunction">wwv_flow_epg_include_modules.authorize</entry>
If it does, either remove it or (better) whitelist your procedures so that ORDS will let them through. They may be more issues, but that could be a start.
Previous Topic: Apex_web_service
Next Topic: Friendly URL rewrite or masking
Goto Forum:

Current Time: Thu May 26 22:53:47 CDT 2022