APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

utl_http and proxy

victorpJun 28 2006 — edited Feb 26 2007

On htmldb.oracle I execute the following:
 
select utl_http.request('www.google.com','(removed proxy - on our hosted instance, you cannot use web services)') from dual
 
This returns some html - no problems. If I try without the proxy then it doesnt work which is as expected.
 
Now within my client hosted sql window I execute the following:
 
select utl_http.request('www.localaddress.com') from dual
 
This does not specify a proxy as the address is local or whatever. This returns some html - no problems yet.
 
Now I want to try a link that does require proxy so I try
 
select utl_http.request('www.google.com','clientproxy:80') from dual
 
This returns <html><head><title>Error</title></head><body>The parameter is incorrect. </body></html>
 
If I enter the proxy in wrong then it times out / don't work so I guess I have the proxy correct. I got the proxy details by going onto database server, opening browser, lan settings, proxy settings. I can access internet fine from this machine so not sure what problem is. Anyone have any ideas where to start / what to look for? thanks

Message was edited by:
sbkenned

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 26 2006

Added on Jun 28 2006

#apex-discussions

2 comments

619 views