Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Embedded PL/SQL Gateway EPG in DB 12.2 (database 12.2.x)
Embedded PL/SQL Gateway EPG in DB 12.2 [message #676291] Tue, 28 May 2019 05:00
John Watson
Messages: 8135
Registered: January 2010
Location: Global Village
Senior Member
I'm having trouble with the EPG in 12cR2. In 12.1 and earlier, little demos like this work:
exec dbms_epg.drop_dad('scott_dad')
exec dbms_xdb_config.sethttpport(0)

select dbms_xdb_config.gethttpport from dual;
exec dbms_xdb_config.sethttpport(8008)
exec  dbms_epg.create_dad('scott_dad','/scott/*')

create or replace procedure scott.hello_world as begin
htp.print('Hello world at '||to_char(systimestamp));

wget http://SCOTT:tiger@
But in 12.2, all I ever get is
HTTP request sent, awaiting response... 401 Unauthorized
I've tried doing this:
exec dbms_epg.authorize_dad('scott_dad','SCOTT')
exec dbms_epg.set_dad_attribute('scott_dad','database-username','SCOTT')
exec dbms_epg.set_dad_attribute('scott_dad','authentication-mode','Basic')
but I cannot make it work.

Any ideas? A security enhancement in 12.2??

Thank you for any insight.

Previous Topic: Error message in PL/SQL package to APEX page
Next Topic: ORDS ON tomcat
Goto Forum:

Current Time: Mon Jan 27 21:56:16 CST 2020