Reading data from web and output data in Oracle pl/sql

Your job is Reading data from web url and output data in Oracle pl/sql

The idea might be use utl_http to get online data output in oracle pl/sql
The sample utl_http is working and able to output data. Please see below:

BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL (
acl => 'http_permissions1.xml',
description => 'Permissions for http network',
principal => 'your_shchema_name',
is_grant => TRUE,
privilege => 'connect');
END;
/

BEGIN
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL (
acl => 'http_permissions1.xml',
host => 'taolibrary.com',
lower_port => 80,
upper_port => null);
END;
/

grant execute on utl_http to your_shchema_name;
SELECT utl_http.request('http://taolibrary.com') FROM dual;
*******You will get some data output from url http://taolibrary.com *******


However, your challenge is using the following url (data.crea.ca) to get data from web.
1. You must login to the program with username and password
http://data.crea.ca/Login.svc/Login
Username=CXLHfDVrziCfvwgCuL8nUahC
Password=mFqMsCSPdnb5WO1gpEEtDCHH

2. Use utl_http package to print output line by line by dbms_output.put_line('Here it is');
http://data.crea.ca/Search.svc/Search?SearchType=Office&Class=Office&QueryType=DMQL2&Query=(ID=*)
http://data.crea.ca/Search.svc/Search?SearchType=Office&Class=Office&QueryType=DMQL2&Query=(ID=287148)

3. if you can try using other package to achieve same result in Oracle pl/sql language, that's fine. I just want get the url output , the url are :
http://data.crea.ca/Search.svc/Search?SearchType=Office&Class=Office&QueryType=DMQL2&Query=(ID=*)

http://data.crea.ca/Search.svc/Search?SearchType=Office&Class=Office&QueryType=DMQL2&Query=(ID=287148)

4. Price : $100 , I need your solution