Advertisement

02.29.2008 at 01:53AM PST, ID: 23203235 | Points: 500
[x]
Attachment Details

XML response from Oracle Web Service is not well formed

Tags: Oracle, Oracle, 11g, Native Web Services
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</soap:Value>
     </soap:faultcode>
     <soap:faultstring>Error processing input</soap:faultstring>
     <soap:detail>
      <OracleErrors xmlns="http://xmlns.oracle.com/orawsv/faults">
       <OracleError>
        <ErrorNumber>ORA-19202</ErrorNumber>
        <Message><![CDATA[Error occurred in XML processing]]></Message>
      </OracleError>
       <OracleError>
        <ErrorNumber>ORA-01403</ErrorNumber>
        <Message><![CDATA[no data found]]></Message>
      </OracleError>
       <OracleError>
        <ErrorNumber>ORA-06512</ErrorNumber>
        <Message><![CDATA[at "NEUTRINO_SP.NEUTRINO_TEST", line 11]]></Message>
      </OracleError>
       <OracleError>
        <ErrorNumber>ORA-06512</ErrorNumber>
        <Message><![CDATA[at "NEUTRINO_WS.WSTEST", line 5]]></Message>
      </OracleError>
       <OracleError>
        <ErrorNumber>ORA-06512</ErrorNumber>
        <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...
Start your free trial to view this solution
Question Stats
Zone: Database
Question Asked By: darren_k156
Question Asked On: 02.29.2008
Participating Experts: 1
Points: 500
Views: 0
Translate:
Loading Advertisement...
03.07.2008 at 11:04PM PST, ID: 21076179

Rank: Master

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
03.10.2008 at 04:05AM PDT, ID: 21085295

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
Loading Advertisement...
20080236-EE-VQP-29 / EE_QW_2_20070628