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
kent.vickery
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:

PROCEDURE Hello is
BEGIN
    htp.init;
    htp.p('Hello.');
END;
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)

BEGIN

	ords.enable_schema(
		p_enabled		=> TRUE,
		p_schema		=> 'GATOR',
		p_url_mapping_type	=> 'BASE_PATH',
		p_url_mapping_pattern	=> 'gator',
		p_auto_rest_auth	=> FALSE
		);
		
	COMMIT;

END;
/
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: 8644
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
Goto Forum:
  


Current Time: Mon Dec 06 08:55:02 CST 2021