Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Problem requesting PL/SQL web page through ORDS

User_0ZK6UOct 13 2021

I have a PL/SQL web application that I am trying to migrate to ORDS. I have setup Oracle Database 18 XE, APEX 20.2, and ORDS 20.3, with Tomcat 8.5.
I have a public procedure, shown below, in a database package that I want to have run when I go to localhost:8080/ords/gator/gator$session.Hello, but currently I am getting a 400 Page Not Found error. The package compiles without errors and ORDS is running on Tomcat. What have I not setup properly?
----------------
PL/SQL Procedure (within package gator$session)
----------------
PROCEDURE Hello IS
BEGIN
htp.init;
htp.p('GATOR says Hello.');
END;
------------------------------
Setup steps with SYS as SYSDBA
------------------------------
alter session set container=XEPDB1;

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

alter user GATOR grant connect through ORDS_PUBLIC_USER;

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;

-----------------------------------
Setup steps with 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;
/

Comments
Post Details
Added on Oct 13 2021
9 comments
218 views