vahid83
دوشنبه 24 تیر 1392, 18:34 عصر
دوستان بازم سلام
من وب سرويسي دارم كه ميخوام از خود اوراكل فراخواني اش كنم. كارهاي زيادي انجام دادم كه در زير آوردم.
ابتدا Soap_api رو به Schema مورد نظرم اضافه كردم. بعد Stored Procedure رو به Schema اضافه كردم:
CREATE OR REPLACE
FUNCTION GETMANUAL(p1 IN VARCHAR2,p2 IN VARCHAR2,p3 IN VARCHAR2,p4 IN VARCHAR2)
RETURN VARCHAR2
AS
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);
BEGIN
--l_response_paylod XMLType;
l_url := 'http://192.168.1.105/abn_webservice/abn_data.asmx';
l_namespace := 'http://tempuri.org/';
l_method := 'MANUAL_MOSH_CHANGES';
l_soap_action := 'http://tempuri.org/MANUAL_MOSH_CHANGES';
l_result_name := 'MANUAL_MOSH_CHANGESResult';
l_request := soap_api.new_request(p_method =>l_method,
p_namespace =>l_namespace);
soap_api.add_parameter(p_request => l_request,
p_name => 'User_Name',
p_type => 's:string',
p_value => p1);
soap_api.add_parameter(p_request => l_request,
p_name => 'Password',
p_type => 's:string',
p_value => p2);
soap_api.add_parameter(p_request => l_request,p_name=>'Start_Date',p_type=>'xsd:string',p_value=>p3);
soap_api.add_parameter(p_request => l_request,p_name=>'End_Date',p_type=>'xsd:string',p_value=>p4);
l_response := soap_api.invoke(p_request => l_request,p_url => l_url,p_action => l_soap_action);
l_return := soap_api.get_return_value(p_response => l_response,p_name => l_result_name,p_namespace => NULL);
RETURN l_return;
END;
در رابطه با ACL خطا داد كه تنظيماتش رو در sys انجام دادم تا مشكل حل بشه:
CREATE OR REPLACE
PROCEDURE "ACL" AS
BEGIN
dbms_network_acl_admin.create_acl (
acl => 'utl_http.xml',
description => 'HTTP Access',
principal => 'LK',
is_grant => TRUE,
privilege => 'connect',
start_date => null,
end_date => null
);
commit;
dbms_network_acl_admin.add_privilege (
acl => 'utl_http.xml',
principal => 'LK',
is_grant => TRUE,
privilege => 'resolve',
start_date => null,
end_date => null
);
commit;
dbms_network_acl_admin.assign_acl (
acl => 'utl_http.xml',
host => '192.168.1.105',
lower_port => null,
upper_port => null
);
commit;
END;
فايل xml ام هم به صورت زيره:
<?xml version="1.0" encoding="utf-8" ?>
- <wsdl:definitions xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:tm="http://microsoft.com/wsdl/mime/textMatching/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:mime="http://schemas.xmlsoap.org/wsdl/mime/" xmlns:tns="http://tempuri.org/" xmlns:s="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://schemas.xmlsoap.org/wsdl/soap12/" xmlns:http="http://schemas.xmlsoap.org/wsdl/http/" targetNamespace="http://tempuri.org/" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">
- <wsdl:types>
- <s:schema elementFormDefault="qualified" targetNamespace="http://tempuri.org/">
- <s:element name="AUTOMATIC_MOSH_CHANGES">
- <s:complexType>
- <s:sequence>
<s:element minOccurs="0" maxOccurs="1" name="User_Name" type="s:string" />
<s:element minOccurs="0" maxOccurs="1" name="Password" type="s:string" />
</s:sequence>
</s:complexType>
</s:element>
- <s:element name="AUTOMATIC_MOSH_CHANGESResponse">
- <s:complexType>
- <s:sequence>
- <s:element minOccurs="0" maxOccurs="1" name="AUTOMATIC_MOSH_CHANGESResult">
- <s:complexType>
- <s:sequence>
<s:element ref="s:schema" />
<s:any />
</s:sequence>
</s:complexType>
</s:element>
</s:sequence>
</s:complexType>
</s:element>
- <s:element name="MANUAL_MOSH_CHANGES">
+ <s:complexType>
- <s:sequence>
<s:element minOccurs="0" maxOccurs="1" name="User_Name" type="s:string" />
<s:element minOccurs="0" maxOccurs="1" name="Password" type="s:string" />
<s:element minOccurs="0" maxOccurs="1" name="Start_Date" type="s:string" />
<s:element minOccurs="0" maxOccurs="1" name="End_Date" type="s:string" />
</s:sequence>
</s:complexType>
</s:element>
- <s:element name="MANUAL_MOSH_CHANGESResponse">
- <s:complexType>
- <s:sequence>
- <s:element minOccurs="0" maxOccurs="1" name="MANUAL_MOSH_CHANGESResult">
- <s:complexType>
- <s:sequence>
<s:element ref="s:schema" />
<s:any />
</s:sequence>
</s:complexType>
</s:element>
</s:sequence>
</s:complexType>
</s:element>
- <s:element name="GET_CENTERS">
- <s:complexType>
- <s:sequence>
<s:element minOccurs="0" maxOccurs="1" name="User_Name" type="s:string" />
<s:element minOccurs="0" maxOccurs="1" name="Password" type="s:string" />
</s:sequence>
</s:complexType>
</s:element>
- <s:element name="GET_CENTERSResponse">
- <s:complexType>
- <s:sequence>
- <s:element minOccurs="0" maxOccurs="1" name="GET_CENTERSResult">
- <s:complexType>
- <s:sequence>
<s:element ref="s:schema" />
<s:any />
</s:sequence>
</s:complexType>
</s:element>
</s:sequence>
</s:complexType>
</s:element>
- <s:element name="GET_CITIES">
- <s:complexType>
- <s:sequence>
<s:element minOccurs="0" maxOccurs="1" name="User_Name" type="s:string" />
<s:element minOccurs="0" maxOccurs="1" name="Password" type="s:string" />
</s:sequence>
</s:complexType>
</s:element>
- <s:element name="GET_CITIESResponse">
- <s:complexType>
- <s:sequence>
- <s:element minOccurs="0" maxOccurs="1" name="GET_CITIESResult">
- <s:complexType>
- <s:sequence>
<s:element ref="s:schema" />
<s:any />
</s:sequence>
</s:complexType>
</s:element>
</s:sequence>
</s:complexType>
</s:element>
- <s:element name="GET_VAG_TYPES">
- <s:complexType>
- <s:sequence>
<s:element minOccurs="0" maxOccurs="1" name="User_Name" type="s:string" />
<s:element minOccurs="0" maxOccurs="1" name="Password" type="s:string" />
</s:sequence>
</s:complexType>
</s:element>
- <s:element name="GET_VAG_TYPESResponse">
- <s:complexType>
- <s:sequence>
- <s:element minOccurs="0" maxOccurs="1" name="GET_VAG_TYPESResult">
- <s:complexType>
- <s:sequence>
<s:element ref="s:schema" />
<s:any />
</s:sequence>
</s:complexType>
</s:element>
</s:sequence>
</s:complexType>
</s:element>
- <s:element name="GET_SUBMIT_TYPES">
- <s:complexType>
- <s:sequence>
<s:element minOccurs="0" maxOccurs="1" name="User_Name" type="s:string" />
<s:element minOccurs="0" maxOccurs="1" name="Password" type="s:string" />
</s:sequence>
</s:complexType>
</s:element>
- <s:element name="GET_SUBMIT_TYPESResponse">
- <s:complexType>
- <s:sequence>
- <s:element minOccurs="0" maxOccurs="1" name="GET_SUBMIT_TYPESResult">
- <s:complexType>
- <s:sequence>
<s:element ref="s:schema" />
<s:any />
</s:sequence>
</s:complexType>
</s:element>
</s:sequence>
</s:complexType>
</s:element>
- <s:element name="GET_QUOTAS">
- <s:complexType>
- <s:sequence>
<s:element minOccurs="0" maxOccurs="1" name="User_Name" type="s:string" />
<s:element minOccurs="0" maxOccurs="1" name="Password" type="s:string" />
</s:sequence>
</s:complexType>
</s:element>
- <s:element name="GET_QUOTASResponse">
- <s:complexType>
- <s:sequence>
- <s:element minOccurs="0" maxOccurs="1" name="GET_QUOTASResult">
- <s:complexType>
- <s:sequence>
<s:element ref="s:schema" />
<s:any />
</s:sequence>
</s:complexType>
</s:element>
</s:sequence>
</s:complexType>
</s:element>
- <s:element name="GET_IMP_TELEPHONES">
- <s:complexType>
- <s:sequence>
<s:element minOccurs="0" maxOccurs="1" name="User_Name" type="s:string" />
<s:element minOccurs="0" maxOccurs="1" name="Password" type="s:string" />
</s:sequence>
</s:complexType>
</s:element>
- <s:element name="GET_IMP_TELEPHONESResponse">
- <s:complexType>
- <s:sequence>
- <s:element minOccurs="0" maxOccurs="1" name="GET_IMP_TELEPHONESResult">
- <s:complexType>
- <s:sequence>
<s:element ref="s:schema" />
<s:any />
</s:sequence>
</s:complexType>
</s:element>
</s:sequence>
</s:complexType>
</s:element>
- <s:element name="GET_TELEPHONE_TYPES">
- <s:complexType>
- <s:sequence>
<s:element minOccurs="0" maxOccurs="1" name="User_Name" type="s:string" />
<s:element minOccurs="0" maxOccurs="1" name="Password" type="s:string" />
</s:sequence>
</s:complexType>
</s:element>
- <s:element name="GET_TELEPHONE_TYPESResponse">
- <s:complexType>
- <s:sequence>
- <s:element minOccurs="0" maxOccurs="1" name="GET_TELEPHONE_TYPESResult">
- <s:complexType>
- <s:sequence>
<s:element ref="s:schema" />
<s:any />
</s:sequence>
</s:complexType>
</s:element>
</s:sequence>
</s:complexType>
</s:element>
</s:schema>
</wsdl:types>
- <wsdl:message name="AUTOMATIC_MOSH_CHANGESSoapIn">
<wsdl:part name="parameters" element="tns:AUTOMATIC_MOSH_CHANGES" />
</wsdl:message>
- <wsdl:message name="AUTOMATIC_MOSH_CHANGESSoapOut">
<wsdl:part name="parameters" element="tns:AUTOMATIC_MOSH_CHANGESResponse" />
</wsdl:message>
- <wsdl:message name="MANUAL_MOSH_CHANGESSoapIn">
<wsdl:part name="parameters" element="tns:MANUAL_MOSH_CHANGES" />
</wsdl:message>
- <wsdl:message name="MANUAL_MOSH_CHANGESSoapOut">
<wsdl:part name="parameters" element="tns:MANUAL_MOSH_CHANGESResponse" />
</wsdl:message>
- <wsdl:message name="GET_CENTERSSoapIn">
<wsdl:part name="parameters" element="tns:GET_CENTERS" />
</wsdl:message>
- <wsdl:message name="GET_CENTERSSoapOut">
<wsdl:part name="parameters" element="tns:GET_CENTERSResponse" />
</wsdl:message>
- <wsdl:message name="GET_CITIESSoapIn">
<wsdl:part name="parameters" element="tns:GET_CITIES" />
</wsdl:message>
- <wsdl:message name="GET_CITIESSoapOut">
<wsdl:part name="parameters" element="tns:GET_CITIESResponse" />
</wsdl:message>
- <wsdl:message name="GET_VAG_TYPESSoapIn">
<wsdl:part name="parameters" element="tns:GET_VAG_TYPES" />
</wsdl:message>
- <wsdl:message name="GET_VAG_TYPESSoapOut">
<wsdl:part name="parameters" element="tns:GET_VAG_TYPESResponse" />
</wsdl:message>
- <wsdl:message name="GET_SUBMIT_TYPESSoapIn">
<wsdl:part name="parameters" element="tns:GET_SUBMIT_TYPES" />
</wsdl:message>
- <wsdl:message name="GET_SUBMIT_TYPESSoapOut">
<wsdl:part name="parameters" element="tns:GET_SUBMIT_TYPESResponse" />
</wsdl:message>
- <wsdl:message name="GET_QUOTASSoapIn">
<wsdl:part name="parameters" element="tns:GET_QUOTAS" />
</wsdl:message>
- <wsdl:message name="GET_QUOTASSoapOut">
<wsdl:part name="parameters" element="tns:GET_QUOTASResponse" />
</wsdl:message>
- <wsdl:message name="GET_IMP_TELEPHONESSoapIn">
<wsdl:part name="parameters" element="tns:GET_IMP_TELEPHONES" />
</wsdl:message>
- <wsdl:message name="GET_IMP_TELEPHONESSoapOut">
<wsdl:part name="parameters" element="tns:GET_IMP_TELEPHONESResponse" />
</wsdl:message>
- <wsdl:message name="GET_TELEPHONE_TYPESSoapIn">
<wsdl:part name="parameters" element="tns:GET_TELEPHONE_TYPES" />
</wsdl:message>
- <wsdl:message name="GET_TELEPHONE_TYPESSoapOut">
<wsdl:part name="parameters" element="tns:GET_TELEPHONE_TYPESResponse" />
</wsdl:message>
- <wsdl:portType name="ABN_DATASoap">
- <wsdl:operation name="AUTOMATIC_MOSH_CHANGES">
<wsdl:input message="tns:AUTOMATIC_MOSH_CHANGESSoapIn" />
<wsdl:output message="tns:AUTOMATIC_MOSH_CHANGESSoapOut" />
</wsdl:operation>
- <wsdl:operation name="MANUAL_MOSH_CHANGES">
<wsdl:input message="tns:MANUAL_MOSH_CHANGESSoapIn" />
<wsdl:output message="tns:MANUAL_MOSH_CHANGESSoapOut" />
</wsdl:operation>
- <wsdl:operation name="GET_CENTERS">
<wsdl:input message="tns:GET_CENTERSSoapIn" />
<wsdl:output message="tns:GET_CENTERSSoapOut" />
</wsdl:operation>
- <wsdl:operation name="GET_CITIES">
<wsdl:input message="tns:GET_CITIESSoapIn" />
<wsdl:output message="tns:GET_CITIESSoapOut" />
</wsdl:operation>
- <wsdl:operation name="GET_VAG_TYPES">
<wsdl:input message="tns:GET_VAG_TYPESSoapIn" />
<wsdl:output message="tns:GET_VAG_TYPESSoapOut" />
</wsdl:operation>
- <wsdl:operation name="GET_SUBMIT_TYPES">
<wsdl:input message="tns:GET_SUBMIT_TYPESSoapIn" />
<wsdl:output message="tns:GET_SUBMIT_TYPESSoapOut" />
</wsdl:operation>
- <wsdl:operation name="GET_QUOTAS">
<wsdl:input message="tns:GET_QUOTASSoapIn" />
<wsdl:output message="tns:GET_QUOTASSoapOut" />
</wsdl:operation>
- <wsdl:operation name="GET_IMP_TELEPHONES">
<wsdl:input message="tns:GET_IMP_TELEPHONESSoapIn" />
<wsdl:output message="tns:GET_IMP_TELEPHONESSoapOut" />
</wsdl:operation>
- <wsdl:operation name="GET_TELEPHONE_TYPES">
<wsdl:input message="tns:GET_TELEPHONE_TYPESSoapIn" />
<wsdl:output message="tns:GET_TELEPHONE_TYPESSoapOut" />
</wsdl:operation>
</wsdl:portType>
- <wsdl:binding name="ABN_DATASoap" type="tns:ABN_DATASoap">
<soap:binding transport="http://schemas.xmlsoap.org/soap/http" />
- <wsdl:operation name="AUTOMATIC_MOSH_CHANGES">
<soap:operation soapAction="http://tempuri.org/AUTOMATIC_MOSH_CHANGES" style="document" />
- <wsdl:input>
<soap:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap:body use="literal" />
</wsdl:output>
</wsdl:operation>
- <wsdl:operation name="MANUAL_MOSH_CHANGES">
<soap:operation soapAction="http://tempuri.org/MANUAL_MOSH_CHANGES" style="document" />
- <wsdl:input>
<soap:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap:body use="literal" />
</wsdl:output>
</wsdl:operation>
- <wsdl:operation name="GET_CENTERS">
<soap:operation soapAction="http://tempuri.org/GET_CENTERS" style="document" />
- <wsdl:input>
<soap:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap:body use="literal" />
</wsdl:output>
</wsdl:operation>
- <wsdl:operation name="GET_CITIES">
<soap:operation soapAction="http://tempuri.org/GET_CITIES" style="document" />
- <wsdl:input>
<soap:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap:body use="literal" />
</wsdl:output>
</wsdl:operation>
- <wsdl:operation name="GET_VAG_TYPES">
<soap:operation soapAction="http://tempuri.org/GET_VAG_TYPES" style="document" />
- <wsdl:input>
<soap:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap:body use="literal" />
</wsdl:output>
</wsdl:operation>
- <wsdl:operation name="GET_SUBMIT_TYPES">
<soap:operation soapAction="http://tempuri.org/GET_SUBMIT_TYPES" style="document" />
- <wsdl:input>
<soap:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap:body use="literal" />
</wsdl:output>
</wsdl:operation>
- <wsdl:operation name="GET_QUOTAS">
<soap:operation soapAction="http://tempuri.org/GET_QUOTAS" style="document" />
- <wsdl:input>
<soap:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap:body use="literal" />
</wsdl:output>
</wsdl:operation>
- <wsdl:operation name="GET_IMP_TELEPHONES">
<soap:operation soapAction="http://tempuri.org/GET_IMP_TELEPHONES" style="document" />
- <wsdl:input>
<soap:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap:body use="literal" />
</wsdl:output>
</wsdl:operation>
- <wsdl:operation name="GET_TELEPHONE_TYPES">
<soap:operation soapAction="http://tempuri.org/GET_TELEPHONE_TYPES" style="document" />
- <wsdl:input>
<soap:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap:body use="literal" />
</wsdl:output>
</wsdl:operation>
</wsdl:binding>
- <wsdl:binding name="ABN_DATASoap12" type="tns:ABN_DATASoap">
<soap12:binding transport="http://schemas.xmlsoap.org/soap/http" />
- <wsdl:operation name="AUTOMATIC_MOSH_CHANGES">
<soap12:operation soapAction="http://tempuri.org/AUTOMATIC_MOSH_CHANGES" style="document" />
- <wsdl:input>
<soap12:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap12:body use="literal" />
</wsdl:output>
</wsdl:operation>
- <wsdl:operation name="MANUAL_MOSH_CHANGES">
<soap12:operation soapAction="http://tempuri.org/MANUAL_MOSH_CHANGES" style="document" />
- <wsdl:input>
<soap12:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap12:body use="literal" />
</wsdl:output>
</wsdl:operation>
- <wsdl:operation name="GET_CENTERS">
<soap12:operation soapAction="http://tempuri.org/GET_CENTERS" style="document" />
- <wsdl:input>
<soap12:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap12:body use="literal" />
</wsdl:output>
</wsdl:operation>
- <wsdl:operation name="GET_CITIES">
<soap12:operation soapAction="http://tempuri.org/GET_CITIES" style="document" />
- <wsdl:input>
<soap12:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap12:body use="literal" />
</wsdl:output>
</wsdl:operation>
- <wsdl:operation name="GET_VAG_TYPES">
<soap12:operation soapAction="http://tempuri.org/GET_VAG_TYPES" style="document" />
- <wsdl:input>
<soap12:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap12:body use="literal" />
</wsdl:output>
</wsdl:operation>
- <wsdl:operation name="GET_SUBMIT_TYPES">
<soap12:operation soapAction="http://tempuri.org/GET_SUBMIT_TYPES" style="document" />
- <wsdl:input>
<soap12:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap12:body use="literal" />
</wsdl:output>
</wsdl:operation>
- <wsdl:operation name="GET_QUOTAS">
<soap12:operation soapAction="http://tempuri.org/GET_QUOTAS" style="document" />
- <wsdl:input>
<soap12:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap12:body use="literal" />
</wsdl:output>
</wsdl:operation>
- <wsdl:operation name="GET_IMP_TELEPHONES">
<soap12:operation soapAction="http://tempuri.org/GET_IMP_TELEPHONES" style="document" />
- <wsdl:input>
<soap12:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap12:body use="literal" />
</wsdl:output>
</wsdl:operation>
- <wsdl:operation name="GET_TELEPHONE_TYPES">
<soap12:operation soapAction="http://tempuri.org/GET_TELEPHONE_TYPES" style="document" />
- <wsdl:input>
<soap12:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap12:body use="literal" />
</wsdl:output>
</wsdl:operation>
</wsdl:binding>
- <wsdl:service name="ABN_DATA">
- <wsdl:port name="ABN_DATASoap" binding="tns:ABN_DATASoap">
<soap:address location="http://192.168.1.105/abn_webservice/abn_data.asmx" />
</wsdl:port>
- <wsdl:port name="ABN_DATASoap12" binding="tns:ABN_DATASoap12">
<soap12:address location="http://192.168.1.105/abn_webservice/abn_data.asmx" />
</wsdl:port>
</wsdl:service>
</wsdl:definitions>
ولي وقتي Stored Procedure رو اجرا مي كنم خطاي زير رو ميگيرم:
Procedure execution failed
ORA-30625: method dispatch on NULL SELF argument is disallowed
ORA-06512: at "LK.SOAP_API", line 159
ORA-29266: end-of-body reached
ORA-06512: at "LK.GETMANUAL", line 37
ORA-06512: at line 1
تو رو خدا بهم بگين مشكل كجاست؟؟؟؟؟؟؟؟؟!!!!!!!!!!!!!!!!!:عص بانی++:
من وب سرويسي دارم كه ميخوام از خود اوراكل فراخواني اش كنم. كارهاي زيادي انجام دادم كه در زير آوردم.
ابتدا Soap_api رو به Schema مورد نظرم اضافه كردم. بعد Stored Procedure رو به Schema اضافه كردم:
CREATE OR REPLACE
FUNCTION GETMANUAL(p1 IN VARCHAR2,p2 IN VARCHAR2,p3 IN VARCHAR2,p4 IN VARCHAR2)
RETURN VARCHAR2
AS
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);
BEGIN
--l_response_paylod XMLType;
l_url := 'http://192.168.1.105/abn_webservice/abn_data.asmx';
l_namespace := 'http://tempuri.org/';
l_method := 'MANUAL_MOSH_CHANGES';
l_soap_action := 'http://tempuri.org/MANUAL_MOSH_CHANGES';
l_result_name := 'MANUAL_MOSH_CHANGESResult';
l_request := soap_api.new_request(p_method =>l_method,
p_namespace =>l_namespace);
soap_api.add_parameter(p_request => l_request,
p_name => 'User_Name',
p_type => 's:string',
p_value => p1);
soap_api.add_parameter(p_request => l_request,
p_name => 'Password',
p_type => 's:string',
p_value => p2);
soap_api.add_parameter(p_request => l_request,p_name=>'Start_Date',p_type=>'xsd:string',p_value=>p3);
soap_api.add_parameter(p_request => l_request,p_name=>'End_Date',p_type=>'xsd:string',p_value=>p4);
l_response := soap_api.invoke(p_request => l_request,p_url => l_url,p_action => l_soap_action);
l_return := soap_api.get_return_value(p_response => l_response,p_name => l_result_name,p_namespace => NULL);
RETURN l_return;
END;
در رابطه با ACL خطا داد كه تنظيماتش رو در sys انجام دادم تا مشكل حل بشه:
CREATE OR REPLACE
PROCEDURE "ACL" AS
BEGIN
dbms_network_acl_admin.create_acl (
acl => 'utl_http.xml',
description => 'HTTP Access',
principal => 'LK',
is_grant => TRUE,
privilege => 'connect',
start_date => null,
end_date => null
);
commit;
dbms_network_acl_admin.add_privilege (
acl => 'utl_http.xml',
principal => 'LK',
is_grant => TRUE,
privilege => 'resolve',
start_date => null,
end_date => null
);
commit;
dbms_network_acl_admin.assign_acl (
acl => 'utl_http.xml',
host => '192.168.1.105',
lower_port => null,
upper_port => null
);
commit;
END;
فايل xml ام هم به صورت زيره:
<?xml version="1.0" encoding="utf-8" ?>
- <wsdl:definitions xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:tm="http://microsoft.com/wsdl/mime/textMatching/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:mime="http://schemas.xmlsoap.org/wsdl/mime/" xmlns:tns="http://tempuri.org/" xmlns:s="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://schemas.xmlsoap.org/wsdl/soap12/" xmlns:http="http://schemas.xmlsoap.org/wsdl/http/" targetNamespace="http://tempuri.org/" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">
- <wsdl:types>
- <s:schema elementFormDefault="qualified" targetNamespace="http://tempuri.org/">
- <s:element name="AUTOMATIC_MOSH_CHANGES">
- <s:complexType>
- <s:sequence>
<s:element minOccurs="0" maxOccurs="1" name="User_Name" type="s:string" />
<s:element minOccurs="0" maxOccurs="1" name="Password" type="s:string" />
</s:sequence>
</s:complexType>
</s:element>
- <s:element name="AUTOMATIC_MOSH_CHANGESResponse">
- <s:complexType>
- <s:sequence>
- <s:element minOccurs="0" maxOccurs="1" name="AUTOMATIC_MOSH_CHANGESResult">
- <s:complexType>
- <s:sequence>
<s:element ref="s:schema" />
<s:any />
</s:sequence>
</s:complexType>
</s:element>
</s:sequence>
</s:complexType>
</s:element>
- <s:element name="MANUAL_MOSH_CHANGES">
+ <s:complexType>
- <s:sequence>
<s:element minOccurs="0" maxOccurs="1" name="User_Name" type="s:string" />
<s:element minOccurs="0" maxOccurs="1" name="Password" type="s:string" />
<s:element minOccurs="0" maxOccurs="1" name="Start_Date" type="s:string" />
<s:element minOccurs="0" maxOccurs="1" name="End_Date" type="s:string" />
</s:sequence>
</s:complexType>
</s:element>
- <s:element name="MANUAL_MOSH_CHANGESResponse">
- <s:complexType>
- <s:sequence>
- <s:element minOccurs="0" maxOccurs="1" name="MANUAL_MOSH_CHANGESResult">
- <s:complexType>
- <s:sequence>
<s:element ref="s:schema" />
<s:any />
</s:sequence>
</s:complexType>
</s:element>
</s:sequence>
</s:complexType>
</s:element>
- <s:element name="GET_CENTERS">
- <s:complexType>
- <s:sequence>
<s:element minOccurs="0" maxOccurs="1" name="User_Name" type="s:string" />
<s:element minOccurs="0" maxOccurs="1" name="Password" type="s:string" />
</s:sequence>
</s:complexType>
</s:element>
- <s:element name="GET_CENTERSResponse">
- <s:complexType>
- <s:sequence>
- <s:element minOccurs="0" maxOccurs="1" name="GET_CENTERSResult">
- <s:complexType>
- <s:sequence>
<s:element ref="s:schema" />
<s:any />
</s:sequence>
</s:complexType>
</s:element>
</s:sequence>
</s:complexType>
</s:element>
- <s:element name="GET_CITIES">
- <s:complexType>
- <s:sequence>
<s:element minOccurs="0" maxOccurs="1" name="User_Name" type="s:string" />
<s:element minOccurs="0" maxOccurs="1" name="Password" type="s:string" />
</s:sequence>
</s:complexType>
</s:element>
- <s:element name="GET_CITIESResponse">
- <s:complexType>
- <s:sequence>
- <s:element minOccurs="0" maxOccurs="1" name="GET_CITIESResult">
- <s:complexType>
- <s:sequence>
<s:element ref="s:schema" />
<s:any />
</s:sequence>
</s:complexType>
</s:element>
</s:sequence>
</s:complexType>
</s:element>
- <s:element name="GET_VAG_TYPES">
- <s:complexType>
- <s:sequence>
<s:element minOccurs="0" maxOccurs="1" name="User_Name" type="s:string" />
<s:element minOccurs="0" maxOccurs="1" name="Password" type="s:string" />
</s:sequence>
</s:complexType>
</s:element>
- <s:element name="GET_VAG_TYPESResponse">
- <s:complexType>
- <s:sequence>
- <s:element minOccurs="0" maxOccurs="1" name="GET_VAG_TYPESResult">
- <s:complexType>
- <s:sequence>
<s:element ref="s:schema" />
<s:any />
</s:sequence>
</s:complexType>
</s:element>
</s:sequence>
</s:complexType>
</s:element>
- <s:element name="GET_SUBMIT_TYPES">
- <s:complexType>
- <s:sequence>
<s:element minOccurs="0" maxOccurs="1" name="User_Name" type="s:string" />
<s:element minOccurs="0" maxOccurs="1" name="Password" type="s:string" />
</s:sequence>
</s:complexType>
</s:element>
- <s:element name="GET_SUBMIT_TYPESResponse">
- <s:complexType>
- <s:sequence>
- <s:element minOccurs="0" maxOccurs="1" name="GET_SUBMIT_TYPESResult">
- <s:complexType>
- <s:sequence>
<s:element ref="s:schema" />
<s:any />
</s:sequence>
</s:complexType>
</s:element>
</s:sequence>
</s:complexType>
</s:element>
- <s:element name="GET_QUOTAS">
- <s:complexType>
- <s:sequence>
<s:element minOccurs="0" maxOccurs="1" name="User_Name" type="s:string" />
<s:element minOccurs="0" maxOccurs="1" name="Password" type="s:string" />
</s:sequence>
</s:complexType>
</s:element>
- <s:element name="GET_QUOTASResponse">
- <s:complexType>
- <s:sequence>
- <s:element minOccurs="0" maxOccurs="1" name="GET_QUOTASResult">
- <s:complexType>
- <s:sequence>
<s:element ref="s:schema" />
<s:any />
</s:sequence>
</s:complexType>
</s:element>
</s:sequence>
</s:complexType>
</s:element>
- <s:element name="GET_IMP_TELEPHONES">
- <s:complexType>
- <s:sequence>
<s:element minOccurs="0" maxOccurs="1" name="User_Name" type="s:string" />
<s:element minOccurs="0" maxOccurs="1" name="Password" type="s:string" />
</s:sequence>
</s:complexType>
</s:element>
- <s:element name="GET_IMP_TELEPHONESResponse">
- <s:complexType>
- <s:sequence>
- <s:element minOccurs="0" maxOccurs="1" name="GET_IMP_TELEPHONESResult">
- <s:complexType>
- <s:sequence>
<s:element ref="s:schema" />
<s:any />
</s:sequence>
</s:complexType>
</s:element>
</s:sequence>
</s:complexType>
</s:element>
- <s:element name="GET_TELEPHONE_TYPES">
- <s:complexType>
- <s:sequence>
<s:element minOccurs="0" maxOccurs="1" name="User_Name" type="s:string" />
<s:element minOccurs="0" maxOccurs="1" name="Password" type="s:string" />
</s:sequence>
</s:complexType>
</s:element>
- <s:element name="GET_TELEPHONE_TYPESResponse">
- <s:complexType>
- <s:sequence>
- <s:element minOccurs="0" maxOccurs="1" name="GET_TELEPHONE_TYPESResult">
- <s:complexType>
- <s:sequence>
<s:element ref="s:schema" />
<s:any />
</s:sequence>
</s:complexType>
</s:element>
</s:sequence>
</s:complexType>
</s:element>
</s:schema>
</wsdl:types>
- <wsdl:message name="AUTOMATIC_MOSH_CHANGESSoapIn">
<wsdl:part name="parameters" element="tns:AUTOMATIC_MOSH_CHANGES" />
</wsdl:message>
- <wsdl:message name="AUTOMATIC_MOSH_CHANGESSoapOut">
<wsdl:part name="parameters" element="tns:AUTOMATIC_MOSH_CHANGESResponse" />
</wsdl:message>
- <wsdl:message name="MANUAL_MOSH_CHANGESSoapIn">
<wsdl:part name="parameters" element="tns:MANUAL_MOSH_CHANGES" />
</wsdl:message>
- <wsdl:message name="MANUAL_MOSH_CHANGESSoapOut">
<wsdl:part name="parameters" element="tns:MANUAL_MOSH_CHANGESResponse" />
</wsdl:message>
- <wsdl:message name="GET_CENTERSSoapIn">
<wsdl:part name="parameters" element="tns:GET_CENTERS" />
</wsdl:message>
- <wsdl:message name="GET_CENTERSSoapOut">
<wsdl:part name="parameters" element="tns:GET_CENTERSResponse" />
</wsdl:message>
- <wsdl:message name="GET_CITIESSoapIn">
<wsdl:part name="parameters" element="tns:GET_CITIES" />
</wsdl:message>
- <wsdl:message name="GET_CITIESSoapOut">
<wsdl:part name="parameters" element="tns:GET_CITIESResponse" />
</wsdl:message>
- <wsdl:message name="GET_VAG_TYPESSoapIn">
<wsdl:part name="parameters" element="tns:GET_VAG_TYPES" />
</wsdl:message>
- <wsdl:message name="GET_VAG_TYPESSoapOut">
<wsdl:part name="parameters" element="tns:GET_VAG_TYPESResponse" />
</wsdl:message>
- <wsdl:message name="GET_SUBMIT_TYPESSoapIn">
<wsdl:part name="parameters" element="tns:GET_SUBMIT_TYPES" />
</wsdl:message>
- <wsdl:message name="GET_SUBMIT_TYPESSoapOut">
<wsdl:part name="parameters" element="tns:GET_SUBMIT_TYPESResponse" />
</wsdl:message>
- <wsdl:message name="GET_QUOTASSoapIn">
<wsdl:part name="parameters" element="tns:GET_QUOTAS" />
</wsdl:message>
- <wsdl:message name="GET_QUOTASSoapOut">
<wsdl:part name="parameters" element="tns:GET_QUOTASResponse" />
</wsdl:message>
- <wsdl:message name="GET_IMP_TELEPHONESSoapIn">
<wsdl:part name="parameters" element="tns:GET_IMP_TELEPHONES" />
</wsdl:message>
- <wsdl:message name="GET_IMP_TELEPHONESSoapOut">
<wsdl:part name="parameters" element="tns:GET_IMP_TELEPHONESResponse" />
</wsdl:message>
- <wsdl:message name="GET_TELEPHONE_TYPESSoapIn">
<wsdl:part name="parameters" element="tns:GET_TELEPHONE_TYPES" />
</wsdl:message>
- <wsdl:message name="GET_TELEPHONE_TYPESSoapOut">
<wsdl:part name="parameters" element="tns:GET_TELEPHONE_TYPESResponse" />
</wsdl:message>
- <wsdl:portType name="ABN_DATASoap">
- <wsdl:operation name="AUTOMATIC_MOSH_CHANGES">
<wsdl:input message="tns:AUTOMATIC_MOSH_CHANGESSoapIn" />
<wsdl:output message="tns:AUTOMATIC_MOSH_CHANGESSoapOut" />
</wsdl:operation>
- <wsdl:operation name="MANUAL_MOSH_CHANGES">
<wsdl:input message="tns:MANUAL_MOSH_CHANGESSoapIn" />
<wsdl:output message="tns:MANUAL_MOSH_CHANGESSoapOut" />
</wsdl:operation>
- <wsdl:operation name="GET_CENTERS">
<wsdl:input message="tns:GET_CENTERSSoapIn" />
<wsdl:output message="tns:GET_CENTERSSoapOut" />
</wsdl:operation>
- <wsdl:operation name="GET_CITIES">
<wsdl:input message="tns:GET_CITIESSoapIn" />
<wsdl:output message="tns:GET_CITIESSoapOut" />
</wsdl:operation>
- <wsdl:operation name="GET_VAG_TYPES">
<wsdl:input message="tns:GET_VAG_TYPESSoapIn" />
<wsdl:output message="tns:GET_VAG_TYPESSoapOut" />
</wsdl:operation>
- <wsdl:operation name="GET_SUBMIT_TYPES">
<wsdl:input message="tns:GET_SUBMIT_TYPESSoapIn" />
<wsdl:output message="tns:GET_SUBMIT_TYPESSoapOut" />
</wsdl:operation>
- <wsdl:operation name="GET_QUOTAS">
<wsdl:input message="tns:GET_QUOTASSoapIn" />
<wsdl:output message="tns:GET_QUOTASSoapOut" />
</wsdl:operation>
- <wsdl:operation name="GET_IMP_TELEPHONES">
<wsdl:input message="tns:GET_IMP_TELEPHONESSoapIn" />
<wsdl:output message="tns:GET_IMP_TELEPHONESSoapOut" />
</wsdl:operation>
- <wsdl:operation name="GET_TELEPHONE_TYPES">
<wsdl:input message="tns:GET_TELEPHONE_TYPESSoapIn" />
<wsdl:output message="tns:GET_TELEPHONE_TYPESSoapOut" />
</wsdl:operation>
</wsdl:portType>
- <wsdl:binding name="ABN_DATASoap" type="tns:ABN_DATASoap">
<soap:binding transport="http://schemas.xmlsoap.org/soap/http" />
- <wsdl:operation name="AUTOMATIC_MOSH_CHANGES">
<soap:operation soapAction="http://tempuri.org/AUTOMATIC_MOSH_CHANGES" style="document" />
- <wsdl:input>
<soap:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap:body use="literal" />
</wsdl:output>
</wsdl:operation>
- <wsdl:operation name="MANUAL_MOSH_CHANGES">
<soap:operation soapAction="http://tempuri.org/MANUAL_MOSH_CHANGES" style="document" />
- <wsdl:input>
<soap:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap:body use="literal" />
</wsdl:output>
</wsdl:operation>
- <wsdl:operation name="GET_CENTERS">
<soap:operation soapAction="http://tempuri.org/GET_CENTERS" style="document" />
- <wsdl:input>
<soap:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap:body use="literal" />
</wsdl:output>
</wsdl:operation>
- <wsdl:operation name="GET_CITIES">
<soap:operation soapAction="http://tempuri.org/GET_CITIES" style="document" />
- <wsdl:input>
<soap:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap:body use="literal" />
</wsdl:output>
</wsdl:operation>
- <wsdl:operation name="GET_VAG_TYPES">
<soap:operation soapAction="http://tempuri.org/GET_VAG_TYPES" style="document" />
- <wsdl:input>
<soap:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap:body use="literal" />
</wsdl:output>
</wsdl:operation>
- <wsdl:operation name="GET_SUBMIT_TYPES">
<soap:operation soapAction="http://tempuri.org/GET_SUBMIT_TYPES" style="document" />
- <wsdl:input>
<soap:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap:body use="literal" />
</wsdl:output>
</wsdl:operation>
- <wsdl:operation name="GET_QUOTAS">
<soap:operation soapAction="http://tempuri.org/GET_QUOTAS" style="document" />
- <wsdl:input>
<soap:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap:body use="literal" />
</wsdl:output>
</wsdl:operation>
- <wsdl:operation name="GET_IMP_TELEPHONES">
<soap:operation soapAction="http://tempuri.org/GET_IMP_TELEPHONES" style="document" />
- <wsdl:input>
<soap:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap:body use="literal" />
</wsdl:output>
</wsdl:operation>
- <wsdl:operation name="GET_TELEPHONE_TYPES">
<soap:operation soapAction="http://tempuri.org/GET_TELEPHONE_TYPES" style="document" />
- <wsdl:input>
<soap:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap:body use="literal" />
</wsdl:output>
</wsdl:operation>
</wsdl:binding>
- <wsdl:binding name="ABN_DATASoap12" type="tns:ABN_DATASoap">
<soap12:binding transport="http://schemas.xmlsoap.org/soap/http" />
- <wsdl:operation name="AUTOMATIC_MOSH_CHANGES">
<soap12:operation soapAction="http://tempuri.org/AUTOMATIC_MOSH_CHANGES" style="document" />
- <wsdl:input>
<soap12:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap12:body use="literal" />
</wsdl:output>
</wsdl:operation>
- <wsdl:operation name="MANUAL_MOSH_CHANGES">
<soap12:operation soapAction="http://tempuri.org/MANUAL_MOSH_CHANGES" style="document" />
- <wsdl:input>
<soap12:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap12:body use="literal" />
</wsdl:output>
</wsdl:operation>
- <wsdl:operation name="GET_CENTERS">
<soap12:operation soapAction="http://tempuri.org/GET_CENTERS" style="document" />
- <wsdl:input>
<soap12:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap12:body use="literal" />
</wsdl:output>
</wsdl:operation>
- <wsdl:operation name="GET_CITIES">
<soap12:operation soapAction="http://tempuri.org/GET_CITIES" style="document" />
- <wsdl:input>
<soap12:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap12:body use="literal" />
</wsdl:output>
</wsdl:operation>
- <wsdl:operation name="GET_VAG_TYPES">
<soap12:operation soapAction="http://tempuri.org/GET_VAG_TYPES" style="document" />
- <wsdl:input>
<soap12:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap12:body use="literal" />
</wsdl:output>
</wsdl:operation>
- <wsdl:operation name="GET_SUBMIT_TYPES">
<soap12:operation soapAction="http://tempuri.org/GET_SUBMIT_TYPES" style="document" />
- <wsdl:input>
<soap12:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap12:body use="literal" />
</wsdl:output>
</wsdl:operation>
- <wsdl:operation name="GET_QUOTAS">
<soap12:operation soapAction="http://tempuri.org/GET_QUOTAS" style="document" />
- <wsdl:input>
<soap12:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap12:body use="literal" />
</wsdl:output>
</wsdl:operation>
- <wsdl:operation name="GET_IMP_TELEPHONES">
<soap12:operation soapAction="http://tempuri.org/GET_IMP_TELEPHONES" style="document" />
- <wsdl:input>
<soap12:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap12:body use="literal" />
</wsdl:output>
</wsdl:operation>
- <wsdl:operation name="GET_TELEPHONE_TYPES">
<soap12:operation soapAction="http://tempuri.org/GET_TELEPHONE_TYPES" style="document" />
- <wsdl:input>
<soap12:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap12:body use="literal" />
</wsdl:output>
</wsdl:operation>
</wsdl:binding>
- <wsdl:service name="ABN_DATA">
- <wsdl:port name="ABN_DATASoap" binding="tns:ABN_DATASoap">
<soap:address location="http://192.168.1.105/abn_webservice/abn_data.asmx" />
</wsdl:port>
- <wsdl:port name="ABN_DATASoap12" binding="tns:ABN_DATASoap12">
<soap12:address location="http://192.168.1.105/abn_webservice/abn_data.asmx" />
</wsdl:port>
</wsdl:service>
</wsdl:definitions>
ولي وقتي Stored Procedure رو اجرا مي كنم خطاي زير رو ميگيرم:
Procedure execution failed
ORA-30625: method dispatch on NULL SELF argument is disallowed
ORA-06512: at "LK.SOAP_API", line 159
ORA-29266: end-of-body reached
ORA-06512: at "LK.GETMANUAL", line 37
ORA-06512: at line 1
تو رو خدا بهم بگين مشكل كجاست؟؟؟؟؟؟؟؟؟!!!!!!!!!!!!!!!!!:عص بانی++: