Both package and procedure exist there.When i open this package at SQL Developer , i found the procedure in package specifiaction but do not find in Package body.
SQL> show user USER is "SYS" SQL> declare 2 vRequest Utl_Http.req; 3 begin 4 vRequest := Utl_Http.begin_request(url=>'https://www.esendex.com',method=>'POST'); 5 end; 6 / declare * ERROR at line 1: ORA-29273: HTTP request failed ORA-06512: at "SYS.UTL_HTTP", line 1029 ORA-12545: Connect failed because target host or object does not exist ORA-06512: at line 4
SQL> select * from v$version 2 / BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod PL/SQL Release 10.2.0.3.0 - Production CORE 10.2.0.3.0 Production TNS for 32-bit Windows: Version 10.2.0.3.0 - Production NLSRTL Version 10.2.0.3.0 - Production
SQL> set serveroutput on SQL> SQL> DECLARE 2 req utl_http.req; 3 resp utl_http.resp; 4 value VARCHAR2(1024); 5 BEGIN 6 req := utl_http.begin_request('http://www.morganslibrary.org'); 7 utl_http.set_header(req, 'User-Agent', 'Mozilla/4.0'); 8 resp := utl_http.get_response(req); 9 LOOP 10 utl_http.read_line(resp, value, TRUE); 11 dbms_output.put_line(value); 12 END LOOP; 13 utl_http.end_response(resp); 14 EXCEPTION 15 WHEN utl_http.end_of_body THEN 16 utl_http.end_response(resp); 17 END; 18 / DECLARE * ERROR at line 1: ORA-12535: TNS:operation timed out ORA-06512: at "SYS.UTL_HTTP", line 1027 ORA-06512: at line 6
user13653962 wrote:The error says that hostname www.esendex.com cannot resolve into an IPv4 address, or that this IP is not accessible.
vRequest := Utl_Http.begin_request(url=>'https://www.esendex.com',method=>'POST');
ORA-12545: Connect failed because target host or object does not exist
user13653962 wrote:Yes. Your netadmin should be able to provide you with web proxy access to the Internet. In that case, you use the proxy setting of UTL_HTTP to access Internet web servers via the web proxy.
how can i do it via proxy , should i ask to my network admin , if yes then what should i prove him to access this proxy cause they may ask why do i need it.
I havent got yours 2nd point , i reckon it is something which i do not need if i get resolution of proxy server.The point is that server IPs are usually statically assigned. And that the DNS server configuration for hostname resolution (changing a hostname into a usable IPv4 address), may only be configured for the Intranet only.
user13653962 wrote:Nothing strange about it. You likely have an ADSL router of sorts?
strange when i execute the same package using my home internet it worked..
user13653962 wrote:Have never used web services for sending SMS - and if I did, I'm not in your part of the world and local web services will be of no use to you. We use standard TCP for sending SMS. But then we also work for a telecoms company that has its own mobile network. :-)
one last quick question , is there any free web services , i am sneding sms through Essendex 10 days free trial web services,