Hi,
I've signed up for the "always free" autonomous database, it's great!
But, I get....
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1530
ORA-01031: insufficient privileges
when i try...
SELECT utl_http.request('http://www.oracle.com/') FROM dual;
when connected as the ADMIN user
I can't GRANT EXECUTE to utl_http from SYS AS SYSDBA because...
Customers are not given OS logons or SYSDBA privileges to prevent phishing attacking.
So is utl_http not allowed on autonomous databases?
I am aware of ACL but I don't think I've even got that far yet, i've fallen at the first hurdle.
I need to get my data from a third party website (oracle.com above was just an easy example), so any alternative solutions would also be welcome
Thanks
Mark