Kindly, I have an XML DB web service in my database, is there is any way to include the user and password authentication in the WSDL file? or removing the authentication at all?
Thanks ...
<definitions name="SQUARE"
targetNamespace="http://xmlns.oracle.com/orawsv/TEST/SQUARE"
xmlns="http://schemas.xmlsoap.org/wsdl/"
xmlns:tns="http://xmlns.oracle.com/orawsv/TEST/SQUARE"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/">
<types>
<xsd:schema targetNamespace="http://xmlns.oracle.com/orawsv/TEST/SQUARE"
elementFormDefault="qualified">
<xsd:element name="SQUAREInput">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="PARM-NUMBER-INOUT" type="xsd:double"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="SQUAREOutput">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="PARM" type="xsd:double"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:schema>
</types>
<message name="SQUAREInputMessage">
<part name="parameters" element="tns:SQUAREInput"/>
</message>
<message name="SQUAREOutputMessage">
<part name="parameters" element="tns:SQUAREOutput"/>
</message>
<portType name="SQUAREPortType">
<operation name="SQUARE">
<input message="tns:SQUAREInputMessage"/>
<output message="tns:SQUAREOutputMessage"/>
</operation>
</portType>
<binding name="SQUAREBinding"
type="tns:SQUAREPortType">
<soap:binding style="document" transport="http://schemas.xmlsoap.org/soap/http"/>
<operation name="SQUARE">
<soap:operation soapAction="SQUARE"/>
<input>
<soap:body parts="parameters" use="literal"/>
</input>
<output>
<soap:body parts="parameters" use="literal"/>
</output>
</operation>
</binding>
<service name="SQUAREService">
<documentation>Oracle Web Service</documentation>
<port name="SQUAREPort" binding="tns:SQUAREBinding">
<soap:address
location="http://192.168.41.74:8077/orawsv/TEST/SQUARE"/>
</port>
</service>
</definitions>
CREATE OR REPLACE PROCEDURE TEST.Square(Parm IN OUT NUMBER) AS
BEGIN
Parm := Parm * 2;
END;