Welcome 微信登录

首页 / 数据库 / MySQL / Oracle中的soaptest

Oracle中的soaptestdeclare
  soap_request varchar2(30000);
  soap_respond varchar2(30000);
  http_req utl_http.req;
  http_resp utl_http.resp;
BEGIN
  soap_request:= "<?xml version="1.0" encoding="utf-8"?>
  <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:tns="http://service.common.rxn.dbs.com">
  <soap:Body>
  <tns:retrieveFAX>
  <tns:umeroId>f001</tns:umeroId>
  </tns:retrieveFAX>
  </soap:Body>
  </soap:Envelope>";  
  http_req:= utl_http.begin_request( "http://127.0.0.1:8080/ipe/services/retrieveFaxService" , "POST" , "HTTP/1.1");  
  utl_http.set_header(http_req, "Content-Type", "text/xml; charset=utf-8");
  utl_http.set_header(http_req, "Content-Length", length(soap_request));
  utl_http.set_header(http_req, "SOAPAction", "urn:receiveFAX");
  utl_http.write_text(http_req, soap_request);
  http_resp:= utl_http.get_response(http_req);
  utl_http.read_text(http_resp, soap_respond);
  utl_http.end_response(http_resp);
END;
/更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12Oracle中的null测试题Oracle 10201升级到10204的ORA-01092问题的解决相关资讯      Oracle高级培训 
  • delete表的数据后恢复  (08/30/2012 08:59:58)
  • 使用ASH信息,发现高CPUsession  (08/14/2012 07:21:32)
  • 如何阅读Oracle Errorstack Output  (08/14/2012 07:15:47)
  • Oracle Apps Patching:adpatch(  (08/16/2012 15:41:37)
  • 话说V$SQL_MONITOR  (08/14/2012 07:19:54)
  • Oracle Apps DBA工具:ADADMIN使用  (08/14/2012 07:00:09)
本文评论 查看全部评论 (0)
表情: 姓名: 字数