2 Replies Latest reply on Sep 29, 2013 8:36 PM by steph0h

    PL/SQL Native Soap (Oracle 11g)

    593076
      I'm attempting to get the SOAP server access to stored procedures working, however I'm not having alot of success.

      I've defined a Test function in the Test Schema

      CREATE FUNCTION Test (tid IN NUMBER,
      mid IN VARCHAR2)
      RETURN VARCHAR2
      IS
      BEGIN
      RETURN 'ABCD12345678901234567890';
      END;
      /

      When I execute (as the intended user)
      select Test.Test(1,'ABC') from dual;
      I get
      ABCD12345678901234567890

      When I access it via http://192.168.0.100:1080/orawsv/Test/Test?wsdl to get the WSDL, I get authenticated, however the results I get are:

      <?xml version="1.0" ?>
      <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
      <soap:Body>
      <soap:Fault>
      <soap:faultcode>
      <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">Incorrect Input Doc/URL</OracleErrors>
      </soap:detail>
      </soap:Fault>
      </soap:Body>
      </soap:Envelope>

      Test User has the following:

      CONNECT N Y
      XDB_WEBSERVICES N Y
      XDB_WEBSERVICES_OVER_HTTP N Y
      XDB_WEBSERVICES_WITH_PUBLIC N Y

      ops$joe (the user I am connecting as) has the following:

      APPDEV N Y (custom role)
      CONNECT N Y
      DBA N Y
      XDB_WEBSERVICES N Y
      XDB_WEBSERVICES_OVER_HTTP N Y
      XDB_WEBSERVICES_WITH_PUBLIC N Y

      Proxied for Users
      User
      Test

      And yes...
      http://192.168.0.100:1080/orawsv?wsdl
      Returns a valid wsdl document which unlike the other is also meaningful :)


      Any hints ?

      Message was edited by:
      user590073