Oracle通过存储过程 采用HTTP的方式调用webserivce

env VARCHAR2(32767);

http_req utl_http.req;

http_resp utl_http.resp;

return_value xmltype;

error_value xmltype;

error_code VARCHAR(256);

error_string VARCHAR2(32767);

result_string varchar2(32767);

BEGIN

env := '<soapenv:Envelope xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance” xmlns:xsd=“http://www.w3.org/2001/XMLSchema” xmlns:soapenv=“http://schemas.xmlsoap.org/soap/envelope/” xmlns:ser=“http://server.webservice.simis.si.neusoft.com”>

soapenv:Header/

soapenv:Body

<ser:ReportTheLossOfSIcard soapenv:encodingStyle=“http://schemas.xmlsoap.org/soap/encoding/”>

452223193711161025||B20684791|4|402|6231330300051198182|450200D156000005A5209A7FE074EFAB|3B6D0000008159532086A24502A5209A7F4

</ser:ReportTheLossOfSIcard>

</soapenv:Body>

</soapenv:Envelope>

';

http_req := utl_http.begi