SQL & PL/SQL

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!

How call a web service WCF pl/sql

user5514643May 10 2012 — edited May 16 2012

Hi,

I developed a web services using Visual Studio .NET Framework 4.0, and I need call this web service from Store procedure in Oracle 10g, but I don't have Idea how. I have seen some examples in web but that examples not work when I've used.

My web service is developed using WCF and It has the address:
http://10.200.53.250/PeajeElect/Bcac.PeajeElect.Agente_Servicio_ETC.svc

The config specification is:
<endpoint address="" binding="basicHttpBinding" contract="Bcac.PeajeElect.IAgente_Servicio_ETC" bindingConfiguration="TheBasicBindingConfig">
<identity>
<dns value="localhost" />
</identity>
</endpoint>

Somebody can helppe me, please

And the wsdl specification is:

<?xml version="1.0" encoding="utf-8" ?>
- <wsdl:definitions name="Agente_Servicio_ETC" targetNamespace="http://tempuri.org/" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://schemas.xmlsoap.org/wsdl/soap12/" xmlns:tns="http://tempuri.org/" xmlns:wsa="http://schemas.xmlsoap.org/ws/2004/08/addressing" xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy" xmlns:wsap="http://schemas.xmlsoap.org/ws/2004/08/addressing/policy" xmlns:wsaw="http://www.w3.org/2006/05/addressing/wsdl" xmlns:msc="http://schemas.microsoft.com/ws/2005/12/wsdl/contract" xmlns:wsa10="http://www.w3.org/2005/08/addressing" xmlns:wsx="http://schemas.xmlsoap.org/ws/2004/09/mex" xmlns:wsam="http://www.w3.org/2007/05/addressing/metadata">
- <wsdl:types>
- <xsd:schema targetNamespace="http://tempuri.org/Imports">
<xsd:import schemaLocation="http://win-r6ddgayo3y4/PeajeElect/Bcac.PeajeElect.Agente_Servicio_ETC.svc?xsd=xsd0" namespace="http://tempuri.org/" />
<xsd:import schemaLocation="http://win-r6ddgayo3y4/PeajeElect/Bcac.PeajeElect.Agente_Servicio_ETC.svc?xsd=xsd1" namespace="http://schemas.microsoft.com/2003/10/Serialization/" />
</xsd:schema>
</wsdl:types>
- <wsdl:message name="IAgente_Servicio_ETC_ConsultaDeTransacciones_InputMessage">
<wsdl:part name="parameters" element="tns:ConsultaDeTransacciones" />
</wsdl:message>
- <wsdl:message name="IAgente_Servicio_ETC_ConsultaDeTransacciones_OutputMessage">
<wsdl:part name="parameters" element="tns:ConsultaDeTransaccionesResponse" />
</wsdl:message>
- <wsdl:message name="IAgente_Servicio_ETC_ListaDeTags_InputMessage">
<wsdl:part name="parameters" element="tns:ListaDeTags" />
</wsdl:message>
- <wsdl:message name="IAgente_Servicio_ETC_ListaDeTags_OutputMessage">
<wsdl:part name="parameters" element="tns:ListaDeTagsResponse" />
</wsdl:message>
- <wsdl:message name="IAgente_Servicio_ETC_ResultadoListasDeTags_InputMessage">
<wsdl:part name="parameters" element="tns:ResultadoListasDeTags" />
</wsdl:message>
- <wsdl:message name="IAgente_Servicio_ETC_ResultadoListasDeTags_OutputMessage">
<wsdl:part name="parameters" element="tns:ResultadoListasDeTagsResponse" />
</wsdl:message>
- <wsdl:message name="IAgente_Servicio_ETC_TagsPorNumeroDocumento_InputMessage">
<wsdl:part name="parameters" element="tns:TagsPorNumeroDocumento" />
</wsdl:message>
- <wsdl:message name="IAgente_Servicio_ETC_TagsPorNumeroDocumento_OutputMessage">
<wsdl:part name="parameters" element="tns:TagsPorNumeroDocumentoResponse" />
</wsdl:message>
- <wsdl:message name="IAgente_Servicio_ETC_Echo_InputMessage">
<wsdl:part name="parameters" element="tns:Echo" />
</wsdl:message>
- <wsdl:message name="IAgente_Servicio_ETC_Echo_OutputMessage">
<wsdl:part name="parameters" element="tns:EchoResponse" />
</wsdl:message>
- <wsdl:message name="IAgente_Servicio_ETC_ws_add_InputMessage">
<wsdl:part name="parameters" element="tns:ws_add" />
</wsdl:message>
- <wsdl:message name="IAgente_Servicio_ETC_ws_add_OutputMessage">
<wsdl:part name="parameters" element="tns:ws_addResponse" />
</wsdl:message>
- <wsdl:portType name="IAgente_Servicio_ETC">
- <wsdl:operation name="ConsultaDeTransacciones">
<wsdl:input wsaw:Action="http://tempuri.org/IAgente_Servicio_ETC/ConsultaDeTransacciones" message="tns:IAgente_Servicio_ETC_ConsultaDeTransacciones_InputMessage" />
<wsdl:output wsaw:Action="http://tempuri.org/IAgente_Servicio_ETC/ConsultaDeTransaccionesResponse" message="tns:IAgente_Servicio_ETC_ConsultaDeTransacciones_OutputMessage" />
</wsdl:operation>
- <wsdl:operation name="ListaDeTags">
<wsdl:input wsaw:Action="http://tempuri.org/IAgente_Servicio_ETC/ListaDeTags" message="tns:IAgente_Servicio_ETC_ListaDeTags_InputMessage" />
<wsdl:output wsaw:Action="http://tempuri.org/IAgente_Servicio_ETC/ListaDeTagsResponse" message="tns:IAgente_Servicio_ETC_ListaDeTags_OutputMessage" />
</wsdl:operation>
- <wsdl:operation name="ResultadoListasDeTags">
<wsdl:input wsaw:Action="http://tempuri.org/IAgente_Servicio_ETC/ResultadoListasDeTags" message="tns:IAgente_Servicio_ETC_ResultadoListasDeTags_InputMessage" />
<wsdl:output wsaw:Action="http://tempuri.org/IAgente_Servicio_ETC/ResultadoListasDeTagsResponse" message="tns:IAgente_Servicio_ETC_ResultadoListasDeTags_OutputMessage" />
</wsdl:operation>
- <wsdl:operation name="TagsPorNumeroDocumento">
<wsdl:input wsaw:Action="http://tempuri.org/IAgente_Servicio_ETC/TagsPorNumeroDocumento" message="tns:IAgente_Servicio_ETC_TagsPorNumeroDocumento_InputMessage" />
<wsdl:output wsaw:Action="http://tempuri.org/IAgente_Servicio_ETC/TagsPorNumeroDocumentoResponse" message="tns:IAgente_Servicio_ETC_TagsPorNumeroDocumento_OutputMessage" />
</wsdl:operation>
- <wsdl:operation name="Echo">
<wsdl:input wsaw:Action="http://tempuri.org/IAgente_Servicio_ETC/Echo" message="tns:IAgente_Servicio_ETC_Echo_InputMessage" />
<wsdl:output wsaw:Action="http://tempuri.org/IAgente_Servicio_ETC/EchoResponse" message="tns:IAgente_Servicio_ETC_Echo_OutputMessage" />
</wsdl:operation>
- <wsdl:operation name="ws_add">
<wsdl:input wsaw:Action="http://tempuri.org/IAgente_Servicio_ETC/ws_add" message="tns:IAgente_Servicio_ETC_ws_add_InputMessage" />
<wsdl:output wsaw:Action="http://tempuri.org/IAgente_Servicio_ETC/ws_addResponse" message="tns:IAgente_Servicio_ETC_ws_add_OutputMessage" />
</wsdl:operation>
</wsdl:portType>
- <wsdl:binding name="BasicHttpBinding_IAgente_Servicio_ETC" type="tns:IAgente_Servicio_ETC">
<soap:binding transport="http://schemas.xmlsoap.org/soap/http" />
- <wsdl:operation name="ConsultaDeTransacciones">
<soap:operation soapAction="http://tempuri.org/IAgente_Servicio_ETC/ConsultaDeTransacciones" style="document" />
- <wsdl:input>
<soap:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap:body use="literal" />
</wsdl:output>
</wsdl:operation>
- <wsdl:operation name="ListaDeTags">
<soap:operation soapAction="http://tempuri.org/IAgente_Servicio_ETC/ListaDeTags" style="document" />
- <wsdl:input>
<soap:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap:body use="literal" />
</wsdl:output>
</wsdl:operation>
- <wsdl:operation name="ResultadoListasDeTags">
<soap:operation soapAction="http://tempuri.org/IAgente_Servicio_ETC/ResultadoListasDeTags" style="document" />
- <wsdl:input>
<soap:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap:body use="literal" />
</wsdl:output>
</wsdl:operation>
- <wsdl:operation name="TagsPorNumeroDocumento">
<soap:operation soapAction="http://tempuri.org/IAgente_Servicio_ETC/TagsPorNumeroDocumento" style="document" />
- <wsdl:input>
<soap:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap:body use="literal" />
</wsdl:output>
</wsdl:operation>
- <wsdl:operation name="Echo">
<soap:operation soapAction="http://tempuri.org/IAgente_Servicio_ETC/Echo" style="document" />
- <wsdl:input>
<soap:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap:body use="literal" />
</wsdl:output>
</wsdl:operation>
- <wsdl:operation name="ws_add">
<soap:operation soapAction="http://tempuri.org/IAgente_Servicio_ETC/ws_add" style="document" />
- <wsdl:input>
<soap:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap:body use="literal" />
</wsdl:output>
</wsdl:operation>
</wsdl:binding>
- <wsdl:service name="Agente_Servicio_ETC">
- <wsdl:port name="BasicHttpBinding_IAgente_Servicio_ETC" binding="tns:BasicHttpBinding_IAgente_Servicio_ETC">
<soap:address location="http://win-r6ddgayo3y4/PeajeElect/Bcac.PeajeElect.Agente_Servicio_ETC.svc" />
</wsdl:port>
</wsdl:service>
</wsdl:definitions>

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 13 2012

Added on May 10 2012

7 comments

2,306 views