Problème pour contacter un web service
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0
Bonjour,
J'aurai besoin d'aide pour contacter un web service.
Jutilise le package suivant :
http://www.oracle-base.com/articles/...Services9i.php
J'aurais bien aimé tester la méthode getGeoIp du site suivant:
http://www.webservicex.net/WCF/Servi...ls.aspx?SID=46
J'ai également tester sur le site suivant : http://www50.brinkster.com/vbfacileinpt/np.asmx?wsdl
Je dois surment faire une erreur sur les paramètre.
Je reçois l'erreur suivante:
ORA-06503: PL/SQL: Function returned without value
ORA-06512: at "PERALLAPP.TEST_WS_GEOIP", line 58
ORA-06512: at line 5
et pour le premier test, si j'affiche le contenu de la réponse, j'ai ceci:
Code:
1
2
3
4
5
6
7
8
9
| <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://ww
w.w3.org/TR/html4/strict.dtd">
<HTML><HEAD><TITLE>The page
cannot be displayed</TITLE>
<META HTTP-EQUIV="Content-Type"
Content="text/html; charset=Windows-1252">
<STYLE type="te
xt/css">
BODY { font: 8pt/12pt verdana }...... |
ce qui signifie:
Code:
1
2
3
4
5
6
7
8
9
10
11
12
| The page cannot be displayed
The page you are looking for cannot be displayed because an invalid method (H TTP verb) was used to attempt access.
________________________________________
Please try t he following:
• Contact the Web site administra tor if you believe that this request should be allowed.
• Make sure that the Web site address displayed in the a ddress bar of your browser is spelled and formatted correctl y.
HTTP Error 405 - The HTTP verb used to access this page is not allowed.
Internet Information Ser vices (IIS)
________________________________________
Technical Information (for suppor t personnel)
• Go to Microsoft Product Support Servic es and perform a title search for the words HTTP and 405.
• Open IIS Help, which is acc essible in IIS Manager (inetmgr), and search for topics ti tled Setting Application Mappings, Securing Your S ite with Web Site Permissions, and About Custom Error Messages. |
Voici la façon dont j positionne les paramtres:
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
| l_url := 'http://www.webservicex.net';
l_namespace := 'xmlns="' || l_url || '"';
l_method := 'GetGeoIP';
l_soap_action := l_url || '#GetGeoIP';
l_result_name := 'GetGeoIP';
l_request := soap_api_v2.new_request(p_method => l_method,
p_namespace => 'xmlns="http://www.webservicex.net"');--l_namespace);
soap_api_v2.add_parameter(p_request => l_request,
p_name => 'IPAddress',
p_type => 'xsd:string',
p_value => '165.125.65.123'); |
Merci d'avance
