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: 8075
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));
end;
/

wget http://SCOTT:tiger@127.0.0.1:8008/scott/hello_world
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: Sun Dec 08 09:51:34 CST 2019