Search Results htbuf_arr




Overview
Explore in AI Chat

Overview

SYS.HTP (the HyperText Procedures package) is the foundational PL/SQL utility that generates HTML markup from within the Oracle Database. In Oracle EBS 12.1.1 and 12.2.2 it is owned by SYS and classified under the generic OTHER API category, reflecting its role as an infrastructure-level toolkit rather than a business API. The package exposes a comprehensive library of procedural calls that emit HTML tags into an output buffer managed by the companion package SYS.HTF. Together, HTP and HTF form the server-side rendering engine behind the Oracle Applications Framework (OAF) web pages, the Oracle Application Server (mod_plsql) PL/SQL cartridges, and the E-Business Suite's own browser-based self-service screens.

HTP is structured around three logical groups of tags: document structure tags that open and close the HTML document, head-related tags that populate the <HEAD> section, and body element tags that render visible content. Because all markup is produced by PL/SQL procedure calls, developers can build fully dynamic HTML pages entirely within the database tier, without any external web server templating language. This is a core architectural pattern of Oracle EBS's "fat database" design.

Key Procedures and Functions

The documented interface contains 143 procedures and functions, of which the following are representative:

  • Document structure procedures — htmlOpen and htmlClose bracket the entire HTML document; headOpen and headClose bracket the metadata section; bodyOpen and bodyClose bracket the visible page content. bodyOpen accepts background and attribute parameters that map directly to the BODY tag attributes.
  • Head-related element procedures — title emits the page title; htitle renders a numbered or sized heading; base sets the base URL and target; isindex provides the ISINDEX prompt and URL; linkRel and linkRev generate forward and reverse hyperlink relationships; meta emits metadata name/value pairs; nextid establishes identifier sequencing; style and script embed CSS and client-side script blocks.
  • Body element procedures — hr and its synonym line produce horizontal rules; br and nl produce line breaks; header emits a heading with size, alignment, and no-wrap control. Many further procedures (for anchors, lists, tables, images, and form controls) complete the tag library but are not itemized in the excerpt.

Tables Accessed

Per the documented ETRM metadata, SYS.HTP references no database tables directly. All of its work is performed through IN and IN OUT parameters and PL/SQL output buffering via SYS.HTF. Although the package is invoked under APPS synonyms, it does not read or write application tables; any data presented on a generated page is passed in by the calling package. This table-free design is why HTP is classified as OTHER rather than as a business API.

Usage Notes

SYS.HTP is a low-level rendering utility and is normally invoked indirectly. It is called by other PL/SQL packages — the metadata records that six packages reference it — and appears in the call stack whenever EBS renders a web page through mod_plsql or Oracle Applications Framework. Typical callers are custom PL/SQL cartridges registered on the EBS web server, page-level handlers built with the HTML Toolkit, and diagnostic or reporting scripts that need an HTML result. Developers writing custom EBS extensions that must output HTML conventionally use HTP rather than concatenating literal strings, because HTP handles character-set conversion through the ANY_CS character set on text-bearing parameters. The package should never be called from a concurrent program that produces a text or XML output file unless HTML output is explicitly intended.