Search Results http_get




Overview
Explore in AI Chat

Overview

IRC_XML_UTIL is a shared PL/SQL utility package in the Oracle E-Business Suite Applications (APPS) schema, classified as a UTIL API. It provides generic XML and HTTP handling routines consumed by other EBS packages rather than representing a standalone business feature. Its header signature (AUTHID CURRENT_USER) confirms that it executes with the privileges of the invoking user, and the header revision (irxmlutl.pkh 120.1.12020000.2, dated 2012/07/03) places it within the 12.1.1 and 12.2.2 code lines. The package bridges two concerns: extracting values from XML documents (files, CLOBs, or DOM objects) using XPath expressions, and retrieving XML content over HTTP for use in workflow and Oracle XML Publisher processing. Owing to its utility classification, it exposes only four documented program units and no business tables of its own, relying instead on database-supplied XML and web utilities.

Key Procedures and Functions

  • getWFXMLElement — A procedure that reads an element from workflow-related XML for a given item type, item key, activity, and function mode, returning the result through an OUT parameter. It is used to surface workflow message/attribute content to calling workflow logic.
  • valueOf (DOMDocument overload) — A function that returns the value of an XPath expression evaluated against a parsed xmldom.DOMDocument document.
  • valueOf (CLOB overload) — A function that parses an XML document held in a CLOB and returns the value located by the given XPath expression.
  • valueOf (VARCHAR2 overload) — A function that performs the same XPath value extraction against an XML document supplied as a character string.
  • http_get — A function that accepts a URL and returns the response body as a VARCHAR2, providing a simple one-call HTTP retrieval for XML and related content. This is the routine associated with the http_get search term.
  • http_get_pieces — A companion function that retrieves HTTP content in pieces, accommodating responses larger than a single VARCHAR2 value can hold.

Tables Accessed

No application tables are read or written directly. The package operates against database-supplied objects exposed through APPS synonyms: UTL_HTTP for outbound HTTP retrieval, the XMLDOM object type for DOM-based parsing, WF_EVENT_T for workflow event data used by getWFXMLElement, and XMLPARSER and XSLPROCESSOR for parsing and transforming XML payloads. Documented references list UTL_HTTP, XMLDOM, WF_EVENT_T, XMLPARSER, and XSLPROCESSOR as the underlying components.

Usage Notes

Because IRC_XML_UTIL is a utility API, it is invoked from other PL/SQL programs rather than from an end-user form or its own concurrent program. Seven other packages reference it, which is consistent with its role as a reusable helper for XML extraction and HTTP fetch operations. Typical invocations occur in custom or seeded code that needs to pull a value from an XML document by XPath (valueOf), fetch a remote XML resource (http_get or http_get_pieces), or read workflow message elements (getWFXMLElement). When calling http_get, the invocation is subject to normal database network ACL restrictions and UTL_HTTP configuration, so the calling schema or the APPS user must have the appropriate host privileges.