Hi all,
I'm trying to use Oracle Web Services with 11g and I believe everything to be set up correctly and am calling the Web Service function with a VB.Net client.
The steps I have gone through are:
1) Running a script on the Oracle server to enable Web Services
2) Granting the XDB_WEBSERVICES and XDB_WEBSERVICES_OVER_HTTP roles to the Oracle function owner
3) Run the ALTER system register command
4) Enabled the TCP port using DBConsole for the database
5) Run the WSDL generator for the function and saved the WSDL file
6) Added a Web reference to the VB application using the generated WSDL file
7) Tried to execute the function
The error I get back after executing the function is a not well-formed XML document. I've applied SOAP extensions to the VB app to see the XML returned by Oracle and it appears that for 2 different result sets there is an element tag without the element name in. Here are the two XML's returned from Oracle:
1st one with the <RETURN> tag being incorrect
<?xml version="1.0" ?>
<soap:Envelope xmlns:soap="
http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<WSTESTOutput xmlns="
http://xmlns.oracle.com/orawsv/NEUTRINO_WS/WSTEST"><
>testing...</RETURN>
</WSTESTOutput>
</soap:Body>
</soap:Envelope>
2nd one with the <soap:faultcode> tag being incorrect
<?xml version="1.0" ?>
<soap:Envelope xmlns:soap="
http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<soap:Fault><
>
<soap:Value>soap:Sender</s
oap:Value>
</soap:faultcode>
<soap:faultstring>Error processing input</soap:faultstring>
<soap:detail>
<OracleErrors xmlns="
http://xmlns.oracle.com/orawsv/faults">
<OracleError>
<ErrorNumber>ORA-19202</Er
rorNumber>
<Message><![CDATA[Error occurred in XML processing]]></Message>
</OracleError>
<OracleError>
<ErrorNumber>ORA-01403</Er
rorNumber>
<Message><![CDATA[no data found]]></Message>
</OracleError>
<OracleError>
<ErrorNumber>ORA-06512</Er
rorNumber>
<Message><![CDATA[at "NEUTRINO_SP.NEUTRINO_TEST
", line 11]]></Message>
</OracleError>
<OracleError>
<ErrorNumber>ORA-06512</Er
rorNumber>
<Message><![CDATA[at "NEUTRINO_WS.WSTEST", line 5]]></Message>
</OracleError>
<OracleError>
<ErrorNumber>ORA-06512</Er
rorNumber>
<Message><![CDATA[at line 1]]></Message>
</OracleError>
</OracleErrors>
</soap:detail>
</soap:Fault>
</soap:Body>
</soap:Envelope>
Please note I'm using Visual Studio 2008 and Oracle 11.1.0.6 and I've tried this against two separate Oracle installations (different physical machines) so it doesn't look like a machine or installation specific issue
Any help is greatly appreciated...