《PLSQL调用Https的WebService.doc》由会员分享，可在线阅读，更多相关《PLSQL调用Https的WebService.doc（9页珍藏版）》请在金锄头文库上搜索。
1、Oracle EBSweb serviceHttps的WS接口调用Author:鞠锋Creation Date:January 21, 2015Last Updated:一月 27, 2015Document Ref: Version:DRAFT 1AApprovals: Copy Number_Document ControlChange Record3DateAuthorVersionChange Reference20-Mar-12Feng.JuDraft 1aNo Previous DocumentReviewersNamePositionDistributionCopy No.Nam
2、eLocation1Library MasterProject Library2Project Manager34Note To Holders:If you receive an electronic copy of this document and print it out, please write your name on the equivalent of the cover page, for document control purposes.If you receive a hard copy of this document, please write your name
3、on the front cover, for document control purposes.ContentsDocument Controlii1.总体说明21.1.本文档目的22.问题描述32.1.问题描述33.问题分析43.1.自己发布一个webservice43.2.尝试用utl_http44.问题解决54.1.Oracle wallet55.Open and Closed Issues for this Deliverable7Open Issues7Closed Issues71. 总体说明1.1. 本文档目的Webservice是个很常用的开发。这里不对webservice
4、接口开发做主要介绍，本身就是对XML文件的解析读取，例子比较多。本文主要介绍SSL加密的，即HTTPS的webservice的接口访问方式。2. 问题描述2.1. 问题描述问题描述项目上需要做一个访问国外一家公司的Web Service的程序。先是仿照其他项目的一个例子（用的是utl_dbws包），其WSDL URI是以https类型的，调用utl_dbws的create_service方法，报URITYPE出错。结论：utl_dbws的create_service不接受“https”开头的参数。于是，直接调用utl_dbws的create_service_proxy方法，不再报URITYPE
5、的错误，但仍然无法和Web Service连通。3. 问题分析尝试在本机发布一个webservice试试？3.1. 自己发布一个webservice本机发布一个webservice：尝试在本机用JDeveloper新建了一个WebService（http的），通过utl_dbws包可以访问。于是想，是不是utl_dbws不支持https类型的Web Service访问？似乎没什么帮助。3.2. 尝试用utl_http尝试用utl_http：在utl_http这个包的包头上搜关键字”https”。搜到这样一段注释：An Oracle wallet is required in order to
6、make a HTTPS request对应的PROCEDURE是：PROCEDURE set_wallet(path IN VARCHAR2, password IN VARCHAR2 DEFAULT NULL);似乎有些眉目了。关键就在这个Oracle wallet。4. 问题解决4.1. Oracle walletOracle wallet相关信息：从Oracle10gR2开始, 通过使用Oracle Wallet达到任意用户不使用密码登录数据库(非操作系统认证方式)。Wallet的配置方法：第一步：在对应目录下创建wallet目录mkdir wallet第二步：新建walletorap
7、ki wallet create -wallet /home/orauat/wallet/ -pwd wallet123第三步：将WebService服务方提供的安全证书（CA_cert.cer）放到wallet目录下第四步：导入受信任的https安全证书orapki wallet add -wallet /home/orauat/wallet/ -trusted_cert -cert /home/orauat/wallet/CA_cert.cer找客户要了安全证书，配置好wallet。用以下方法验证select utl_http.request(url IN VARCHAR2, proxy
8、in VARCHAR2 DEFAULT NULL, wallet_path IN VARCHAR2 DEFAULT NULL, wallet_password IN VARCHAR2 DEFAULT NULL)from dual;但是还有报错。Why?点开证书看看：发现下面有子证书，于是猜想是否应该把根证书和子证书都安装到服务器上。于是将该证书拆出三个子证书，分别安装到wallet中，再用utl_http包测试。测试成功！剩下的程序和调用http的WebService的程序一样。这里就不介绍基本的调用web service的方法，很多项目都有例子可以参照。5. Open and Closed
9、Issues for this DeliverableAdd open issues that you identify while writing or reviewing this document to the open issues section. As you resolve issues, move them to the closed issues section and keep the issue ID the same. Include an explanation of the resolution.When this deliverable is complete,
10、any open issues should be transferred to the project- or process-level Risk and Issue Log (PJM.CR.040) and managed using a project level Risk and Issue Form (PJM.CR.040). In addition, the open items should remain in the open issues section of this deliverable, but flagged in the resolution column as being transferred.Open IssuesIDIssueResolutionResponsibilityTarget DateImpact DateClosed IssuesIDIssueResolutionResponsibilityTarget DateImpact Date
