Oracle实践之EBS PLSQL 解析Webservice(3)

Doc Ref: 错误！未找到引用源。

INTO v_xml FROM dual; --Webservice 获取信息 dbms_output.put_line('==================解析Webservice 开始======================='); --获取返回状态 FOR v_cor IN c_return(v_xml) LOOP dbms_output.put_line('==================返回头信息================================'); dbms_output.put_line('返回状态 X_RETURN_STATUS=>' || v_cor.x_return_status || ';'); dbms_output.put_line('返回行数 X_RETURN_COUNT=>' || v_cor.x_return_count || ';'); dbms_output.put_line('============================================================'); END LOOP; FOR v_cor IN c_header(v_xml) LOOP dbms_output.put_line('===================行' || l_line_number || '======================================'); dbms_output.put_line('HLY_COMPANY' || ':' || v_cor.hly_company); dbms_output.put_line('EMPLOYEE_NUM' || ':' || v_cor.employee_num); dbms_output.put_line('VENDOR_NUMBER' || ':' || v_cor.vendor_number); dbms_output.put_line('VENDOR_NAME' || ':' || v_cor.vendor_name); dbms_output.put_line('TELE_NUMBER' || ':' || v_cor.tele_number); dbms_output.put_line('DEPART_CODE' || ':' || v_cor.depart_code); dbms_output.put_line('COMPANY_NAME' || ':' || v_cor.company_name); dbms_output.put_line('============================================================'); l_line_number := l_line_number + 1; END LOOP; dbms_output.put_line('==================解析Webservice 结束======================='); END;

PS/SQL调用WS输出结果如下：

错误！未找到引用源。

File Ref: Oracle实践之EBS PL/SQL解析Web Service

Company Confidential - For internal use only

（一）调用Integrated SOA Gateway发布的Web Service 8 of 11

Doc Ref: 错误！未找到引用源。

错误！未找到引用源。

File Ref: Oracle实践之EBS PL/SQL解析Web Service

Company Confidential - For internal use only

（一）调用Integrated SOA Gateway发布的Web Service 9 of 11

Doc Ref: 错误！未找到引用源。

（二）参考文档

在实际应用中，环境和版本与本文可能不同，如果想了解ISG更多的内容请参考以下文档： 文档名称 说明 Oracle? E-Business Suite Integrated SOA Gateway Developer's Guide 官方文档，开发手册 Oracle? E-Business Suite Integrated SOA Gateway Implementation Guide 官方文档，实施手册 Oracle? E-Business Suite Integrated SOA Gateway User's Guide 官方文档，用户手册 Installing Oracle E-Business Suite Integrated SOA Gateway, Release 12 [ID 556540.1] support.oracle文章

错误！未找到引用源。

（二）参考文档File Ref: Oracle实践之EBS PL/SQL解析Web Service

Company Confidential - For internal use only

10 of 11

Doc Ref: 错误！未找到引用源。

Open and Closed Issues for this Deliverable

Open Issues

ID Issue Resolution Responsibility Target Date Impact Date

Closed Issues

ID Issue Resolution Responsibility Target Date Impact Date 错误！未找到引用源。

Open and Closed Issues for this Deliverable 11 of 11

File Ref: Oracle实践之EBS PL/SQL解析Web Service

Company Confidential - For internal use only

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库Oracle实践之EBS PLSQL 解析Webservice(3)在线全文阅读。