I'm trying to capture the thermostat readings from my internal networked thermostat. The thermostat url I'm using is as follows..
"http://user:password@x.x.x.x:8081/get?OID4.1.13=" - I know it's not secure, however, the thermostat doesn't have https and requires a username:password to provide the details.
If I type the above into my browser, I get a response of OID4.1.13=714 where (714 = 71.4 degrees F)
using 11gXE, no matter what I try, i get a "401 Authorisation required" message, yet, if I try this from a oracle 12 database, the exact same syntax works OK
I've tried utl_http.begin_request(p_url) followed by utl_http.set_authentication;
utl_http.begin_request(p_url) followed by utl_http_set_header
I declare a var p_url, and assign the full url definition, and then call "utl_http.request(p_url));"
or do i just wait for 18c XE
(Forgot to say Network ACL is OK - both ports 80 and 8081 are enabled)