PROMPT CREATE OR REPLACE FUNCTION importsku
CREATE OR REPLACE FUNCTION importsku
(P_COMP_CODE 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
UTL_HTTP.SET_PROXY ('http://infotech\59222:Hollywood78$@10.44.0.13:80');
--l_url := 'http://crazyshopperz.com/eurostar/orionws.php';
--l_url := 'http://tempuri.org/IService_EDI/ImportSKU';
l_url := 'http://dlcportal.aramex.com/WS_EDI_TEST_V02/Service_EDI.svc';
l_namespace := 'IService_EDI';
--l_namespace := 'xmlns=http://schemas.xmlsoap.org/soap/"';
l_method := 'IService_EDI/ImportSKU';
l_soap_action := 'http://tempuri.org/IService_EDI/ImportSKU';
l_result_name := 'return';
l_request := soap_api.new_request(p_method => l_method,
p_namespace => l_namespace);
-- FOR I IN (SELECT IMA_ITEM_CODE FROM OW_ITEM_ORNION_TO_ARMX_INT) LOOP
soap_api.add_parameter(p_request => l_request,
p_name => 'RequestedDate',
p_type => 'xsd:string',
p_value => '26-Apr-2016');
soap_api.add_parameter(p_request => l_request,
p_name => 'RequestedSystem',
p_type => 'xsd:string',
p_value => 'TestSystem');
soap_api.add_parameter(p_request => l_request,
p_name => 'Description',
p_type => 'xsd:string',
p_value => 'Description001');
soap_api.add_parameter(p_request => l_request,
p_name => 'Facility',
p_type => 'xsd:string',
p_value => 'WH1');
soap_api.add_parameter(p_request => l_request,
p_name => 'HSCode',
p_type => 'xsd:string',
p_value => 'HSCODE1001');
soap_api.add_parameter(p_request => l_request,
p_name => 'SKU',
p_type => 'xsd:string',
p_value => 'SKU001');
soap_api.add_parameter(p_request => l_request,
p_name => 'SerialCount',
p_type => 'xsd:integer',
p_value => '0');
soap_api.add_parameter(p_request => l_request,
p_name => 'SerialLength',
p_type => 'xsd:integer',
p_value => '30');
soap_api.add_parameter(p_request => l_request,
p_name => 'StorerKey',
p_type => 'xsd:string',
p_value => '47572');
soap_api.add_parameter(p_request => l_request,
p_name => 'UPC',
p_type => 'xsd:string',
p_value => 'BarCode001');
soap_api.add_parameter(p_request => l_request,
p_name => 'SSA_Login',
p_type => 'xsd:string',
p_value => 'wp47572');
soap_api.add_parameter(p_request => l_request,
p_name => 'SSA_Password',
p_type => 'xsd:string',
p_value => 'pass');
dummy('1 - ' || l_request.body);
l_response := soap_api.invoke(p_request => l_request,
p_url => l_url,
p_action => l_soap_action);
dummy(2);
l_return := soap_api.get_return_value(p_response => l_response,
p_name => l_result_name,
p_namespace => NULL);
dummy(3);
--END LOOP;
RETURN l_return;
END;
/
SELECT importsku('001') FROM dual;
ORA-30625: method dispatch on NULL SELF argument is disallowed
ORA-06512: at "ORN11J_MW2901.SOAP_API", line 123
ORA-06512: at "ORN11J_MW2901.SOAP_API", line 163
ORA-06512: at "ORN11J_MW2901.IMPORTSKU", line 98
Vinodh