OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » Problem migrating from MOD

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)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem migrating from MOD_PLSQL to ORDS [message #685036]

Tue, 12 October 2021 16:43

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:

Code: [Select all] [Show/ hide]

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)

Code: [Select all] [Show/ hide]

--
--  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)

Code: [Select all] [Show/ hide]

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;
/

Report message to a moderator

Re: Problem migrating from MOD_PLSQL to ORDS [message #685039 is a reply to message #685036]

Wed, 13 October 2021 01:56

John Watson
Messages: 8976
Registered: January 2010
Location: Global Village

Senior Member

Welcome to the forum.

Does your ORDS defaults.xml file include

Code: [Select all] [Show/ hide]

<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.

Report message to a moderator

Previous Topic:	Apex_web_service
Next Topic:	Friendly URL rewrite or masking

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 10:05:40 CDT 2025