troubleshooting Question

WSDL file problem when calling the webservice from database.

Avatar of irsbenz
irsbenzFlag for Canada asked on
Oracle DatabaseWCFWeb Services
4 Comments1 Solution1088 ViewsLast Modified:
I have created a webservice suing the Java class in Jdeveloper uisng the below link it's successfully created and deployed it into the weblogic server there also its tested succesfully.
But when we call this webservice from the oracle11g database procedure we not getting any output, the procedure and also the WSDL fiile which we are using in the webservice its automatically generated are given below.

 procedure call_webservice(p_printer in varchar2
                              ,p_file in varchar2
                              ,p_type in varchar2 default 'txt') is
    l_request   soap_api.t_request;
    l_response  soap_api.t_response;
    l_return    VARCHAR2(32767);
    l_url          VARCHAR2(32767);
    l_namespace    VARCHAR2(32767);
    l_method       VARCHAR2(32767);
    l_soap_action  varchar2(32767);
    l_result_name  VARCHAR2(32767);
    l_url := '';
    l_namespace := 'xmlns="http://Printfile/"';
    l_method      := 'printFile';
    l_soap_action := '';
    l_result_name := 'return';
    l_request := soap_api.new_request(p_method       => l_method,
                                      p_namespace    => l_namespace);
    soap_api.add_parameter(p_request => l_request,
                           p_name    => 'arg0',
                           p_type    => 'xsd:string',
                           p_value   => p_printer);
    soap_api.add_parameter(p_request => l_request,
                           p_name    => 'arg1',
                           p_type    => 'xsd:string',
                           p_value   => p_file);
    soap_api.add_parameter(p_request => l_request,
                           p_name    => 'arg2',
                           p_type    => 'xsd:string',
                           p_value   => p_type);

    l_response := soap_api.invoke(p_request => l_request,
                                  p_url     => l_url,
                                  p_action  => l_soap_action);
WSDL file:
 <?xml version="1.0" encoding="UTF-8" ?> 
- <!--  Published by JAX-WS RI at RI's version is Oracle JAX-WS 2.1.5. 
- <!--  Generated by JAX-WS RI at RI's version is Oracle JAX-WS 2.1.5. 
- <definitions xmlns:wssutil="" xmlns:wsp="" xmlns:soap="" xmlns:tns="http://Printfile/" xmlns:xsd="" xmlns="" targetNamespace="http://Printfile/" name="PrintService">
  <wsp:UsingPolicy wssutil:Required="true" /> 
- <wsp:Policy wssutil:Id="Mtom.xml">
  <ns1:OptimizedMimeSerialization xmlns:ns1="" /> 
- <types>
- <xsd:schema>
  <xsd:import namespace="http://Printfile/" schemaLocation="" /> 
- <message name="printFile">
  <part name="arg0" type="xsd:string" /> 
  <part name="arg1" type="xsd:string" /> 
  <part name="arg2" type="xsd:string" /> 
  <message name="printFileResponse" /> 
- <message name="Exception">
  <part name="fault" element="tns:Exception" /> 
- <portType name="Print">
- <operation name="printFile" parameterOrder="arg0 arg1 arg2">
  <input message="tns:printFile" /> 
  <output message="tns:printFileResponse" /> 
  <fault message="tns:Exception" name="Exception" /> 
- <binding name="PrintPortBinding" type="tns:Print">
  <wsp:PolicyReference URI="#Mtom.xml" /> 
  <soap:binding transport="" style="rpc" /> 
- <operation name="printFile">
  <soap:operation soapAction="" /> 
- <input>
  <soap:body use="literal" namespace="http://Printfile/" /> 
- <output>
  <soap:body use="literal" namespace="http://Printfile/" /> 
- <fault name="Exception">
  <soap:fault name="Exception" use="literal" /> 
- <service name="PrintService">
- <port name="PrintPort" binding="tns:PrintPortBinding">
  <soap:address location="" /> 
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros