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