SQL & PL/SQL

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