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