Re: Oracle 11g : PL/SQL Native Soap

From: Matthew Harrison <m.harrisson_at_craznar.com>
Date: Tue, 14 Aug 2007 08:31:29 +1000
Message-ID: <13c1mujevo4h57c@corp.supernews.com>

Vladimir M. Zakharychev wrote:

> On Aug 13, 5:13 pm, Matthew Harrison <m.harris..._at_craznar.com> wrote:

>> 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 viahttp://192.168.0.100:1080/orawsv/Test/Test?wsdlto
>> 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>
>>
>> Any hints ?
>>
>> --
>> Pinging self [127.0.0.1] with 32 bites of banana cake:
>>
>> Ping statistics for 127.0.0.1:
>> Slices: Sent = 4, Received = 0, Lost = 4 (100% loss),

> 
> You surely granted XDB_WEBSERVICES and XDB_WEBSERVICES_OVER_HTTP roles
> to the TEST user? The first grant is an absolute minimum required to
> be able to access the schema via XDB over HTTPS, and second grant is
> required for plain HTTP access. And does http://192.168.0.100:1080/orawsv?wsdl
> return a valid WSDL document?
> 

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 :)

-- 
Pinging self [127.0.0.1] with 32 bites of banana cake:

Ping statistics for 127.0.0.1:
     Slices: Sent = 4, Received = 0, Lost = 4 (100% loss),

Received on Mon Aug 13 2007 - 17:31:29 CDT