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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
579 views