Search Results comma_to_ident_arr




Overview
Explore in AI Chat

Overview

OWA_UTIL is a core Oracle-supplied PL/SQL package owned by the SYS schema and shipped as part of the Oracle Web Toolkit (the OWA/HTF/HTP family). In Oracle E-Business Suite 12.1.1 and 12.2.2 it provides the low-level utility layer used to render dynamically generated HTML from the database and to interrogate the environment of an HTTP request. Rather than serving a specific business sub-ledger or transaction, OWA_UTIL delivers the generic primitives — CGI environment inspection, MIME and HTTP header emission, redirection, page and source display, and structured HTML table generation — on which EBS self-service pages, the Oracle Applications Framework (OAF) stack's older HTML paths, and the Oracle HTTP Server (mod_plsql) gateway depend. Its status is VALID in the documented ETRM metadata, and it is classified as a UTIL API.

Key Procedures and Functions

The ETRM metadata documents 55 procedures and functions. The principal entries include:

  • NAME_RESOLVE — resolves a schema-qualified database object name passed through a URL into its component parts, supporting dynamic procedure invocation from the browser.
  • SHOWSOURCE — renders the PL/SQL source text of a stored object as HTML, used for developer diagnostics.
  • SIGNATURE — produces the argument signature of a stored procedure, complementing NAME_RESOLVE during dynamic calls.
  • SHOWPAGE — emits and flushes a complete HTML page, a legacy convenience wrapper for manual output.
  • GET_CGI_ENV and PRINT_CGI_ENV — retrieve a named CGI environment variable, or dump the full set for debugging.
  • MIME_HEADER, STATUS_LINE, and HTTP_HEADER_CLOSE — generate HTTP response headers, status lines, and terminate the header block before the body is written.
  • REDIRECT_URL — issues a browser redirect to a supplied URL.
  • GET_OWA_SERVICE_PATH — returns the DAD service path of the current request.
  • SHOW_QUERY_COLUMNS — displays the columns of a query result, and TABLEPRINT renders a result set as an HTML table.
  • COMMA_TO_IDENT_ARR — converts a comma-delimited string into a PL/SQL identifier array.
  • TABLEOPEN, TABLECAPTION, TABLEHEADERROWOPEN, TABLEHEADER, TABLEHEADERROWCLOSE, and TABLEROWOPEN — granular table-building primitives that let callers construct HTML tables element by element.

Tables Accessed

The documented ETRM metadata lists no application tables referenced through APPS synonyms. OWA_UTIL operates almost entirely on in-memory CGI environment state and on the PL/SQL dictionary views (ALL_SOURCE, ALL_ARGUMENTS) consulted by SHOWSOURCE, SIGNATURE, and NAME_RESOLVE. It is a presentation and request-metadata utility rather than a data-access package.

Usage Notes

OWA_UTIL is referenced by PUBLIC and by eight other objects in the documented dependency list, including HTF, HTP, OWA, OWA_CACHE, OWA_COOKIE, OWA_MATCH, OWA_SEC, and WPG_DOCLOAD. In practice it is invoked implicitly whenever EBS renders a web page through mod_plsql, and explicitly by custom PL/SQL web callers that need to set headers, redirect, debug a request, or emit tabular HTML. Because the package resides in SYS, customisations should call it through the standard PUBLIC synonym rather than recompiling or modifying any component. Given its role as the gateway's output layer, header-related procedures must be invoked before any page body is written.