ORA-29532: Java call terminated by uncaught Java exception:

Hi,
I need to consume a secure web service from PL/SQL, either using utl_http or utl_dbws. I created the outbound SOAP request and have tested the same both using SOAP UI and SAAJ. I am using the same XML to send it through pl/sql and I am encountering the following error.

ORA-29532: Java call terminated by uncaught Java exception: port: {http://records.txdps.state.tx.us/cch/}BasicHttpBinding_ISearchService does not contain operation: validateCredentials

CREATE OR REPLACE FUNCTION PROCOWNER.cchDBWS 
  RETURN VARCHAR2
AS
  l_service          UTL_DBWS.service;
  l_call             UTL_DBWS.call;

l_wsdl_url         VARCHAR2(32767);
  l_namespace        VARCHAR2(32767);
  l_service_qname    UTL_DBWS.qname;
  l_port_qname       UTL_DBWS.qname;
  l_operation_qname  UTL_DBWS.qname;

l_xmltype_in       SYS.XMLTYPE;
  l_xmltype_out      SYS.XMLTYPE;
  l_return           VARCHAR2(300);
BEGIN

l_wsdl_url        := 'https://crimerecords.dps.texas.gov/SecureService/CriminalHistory/SearchService.svc?wsdl';
  l_namespace       := 'http://records.txdps.state.tx.us/cch/';

l_service_qname   := UTL_DBWS.to_qname(l_namespace, 'SearchService');
  l_port_qname      := UTL_DBWS.to_qname(l_namespace, 'BasicHttpBinding_ISearchService');
  l_operation_qname := UTL_DBWS.to_qname(l_namespace, 'validateCredentials');

l_service := UTL_DBWS.create_service (
    wsdl_document_location => URIFACTORY.getURI(l_wsdl_url),
    service_name           => l_service_qname);

l_call := UTL_DBWS.create_call (
    service_handle => l_service,
    port_name      => l_port_qname,
    operation_name => l_operation_qname);

l_xmltype_in := SYS.XMLTYPE('<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/" xmlns:cch="http://records.txdps.state.tx.us/cch"><S:Header><wsse:Security xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" S:mustUnderstand="1"><wsse:UsernameToken xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd" wsu:Id="UsernameToken-2"><wsse:Username>abc</wsse:Username><wsse:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText">123</wsse:Password><wsse:Nonce EncodingType="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-soap-message-security-1.0#Base64Binary">I7JFUNelmF6cViOKuY6UFw==</wsse:Nonce><wsu:Created>2012-05-14T10:29:33.139Z</wsu:Created></wsse:UsernameToken></wsse:Security></S:Header><S:Body><ns2:ValidateCredentials xmlns="http://schemas.datacontract.org/2004/07/CchService.Search" xmlns:ns2="http://records.txdps.state.tx.us/cch" xmlns:ns3="http://schemas.microsoft.com/2003/10/Serialization/"/></S:Body></S:Envelope>');

l_xmltype_out := UTL_DBWS.invoke(call_Handle => l_call,
                                   request     => l_xmltype_in);

UTL_DBWS.release_call (call_handle => l_call);
  UTL_DBWS.release_service (service_handle => l_service);

l_return := l_xmltype_out.extract('//return/text()').getStringVal();
  RETURN l_return;
END;
/

Appreciate all help in fixing the issue.

Thanks in advance

I wouldn't be posting real http addresses on a public forum.

As for your problem, it doesn't look like validateCredentials is available at the endpoint.

WP

Thanks for the quick reply

Corrected line to
l_operation_qname := UTL_DBWS.to_qname(l_namespace, 'ValidateCredentials');

I am now getting the below

ORA-29532: Java call terminated by uncaught Java exception: port: {http://records.txdps.state.tx.us/cch/}BasicHttpBinding_ISearchService does not contain operation: Envelope

Thanks for the quick reply

Corrected line to
l_operation_qname := UTL_DBWS.to_qname(l_namespace, 'ValidateCredentials');

I am now getting the below

ORA-29532: Java call terminated by uncaught Java exception: port: {http://records.txdps.state.tx.us/cch/}BasicHttpBinding_ISearchService does not contain operation: Envelope