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

HTTP request sent, awaiting response... 401 Unauthorized

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

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

exec  dbms_epg.set_dad_attribute('scott_dad','database-username','SCOTT')
exec  dbms_epg.authorize_dad('scott_dad','SCOTT')
alter user anonymous account unlock;

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

C:\Users\john>
C:\Users\john>wget http://127.0.0.1:8080/scott/hello_world
--10:10:07--  http://127.0.0.1:8080/scott/hello_world
           => `hello_world'
Connecting to 127.0.0.1:8080... connected.
HTTP request sent, awaiting response... 200 OK
Length: 51 [text/html]

100%[=================================================================================>] 51            --.--K/s

10:10:07 (2.78 MB/s) - `hello_world' saved [51/51]


C:\Users\john>type hello_world
Hello world at 05-FEB-20 10.10.07.251000000 +00:00

C:\Users\john>