Search Results owa_text

Overview

SYS.OWA_TEXT is a core Oracle-supplied PL/SQL package that forms part of the Oracle Web Agent (OWA) toolkit shipped with the database and leveraged throughout Oracle E-Business Suite releases 12.1.1 and 12.2.2. Its primary business function is to manage and manipulate the multi-part text buffers used by the Oracle HTTP Server's PL/SQL gateway (mod_plsql) and by Oracle Application Framework (OAF) and related self-service components. The package provides the underlying data structure — the "multi" type — that accumulates segmented HTML or plain-text output before it is streamed to the browser, and it offers utilities to create, extend, and render those buffers. Within EBS it is classified as an OTHER API, meaning it is not a business-facing concurrent or forms API but a technical utility consumed by higher-level packages. According to the ETRM metadata the object is VALID in schema SYS and is referenced by the OWA_PATTERN package, which itself underpins numerous web-tier utilities used by Oracle Applications.

Key Procedures and Functions

The documented interface exposes eight elements. The core buffer lifecycle is handled by NEW_MULTI, which initialises a fresh multi-part text structure, and STREAM2MULTI, which appends streamed text segments into that structure. ADD2MULTI extends an existing buffer with additional content, while PRINT_MULTI emits the assembled buffer as output. A parallel set of routines manages row-oriented lists: NEW_ROW_LIST creates a new row-list structure and PRINT_ROW_LIST renders it. These procedures are deliberately low-level; they do not accept business parameters such as organization or ledger identifiers, and they are not intended to be called directly from end-user transactions. Their names describe purpose only, and callers should consult the database package specification for exact signatures, as the ETRM metadata does not enumerate parameter lists.

Tables Accessed

The documented metadata records no base tables referenced by SYS.OWA_TEXT, whether directly or through APPS synonyms. This is consistent with its role as an in-memory text-handling utility: it operates on PL/SQL collection and record types rather than persisting data to the EBS schema. Any storage of generated HTML is the responsibility of the calling web-tier package, not of OWA_TEXT itself.

Usage Notes

SYS.OWA_TEXT is normally invoked indirectly. It is referenced by OWA_PATTERN and other OWA family packages, which are themselves called by mod_plsql-handled procedures, OAF pages, and custom JSP or PL/SQL web applications deployed on the EBS application tier. Developers writing custom web-enabled code in EBS 12.1.1 or 12.2.2 may call NEW_MULTI, ADD2MULTI, and PRINT_MULTI to assemble paginated output, but direct invocation from Oracle Forms or concurrent programs is atypical. Because the package resides in SYS and is exposed publicly, changes to it are governed by database patching and should never be modified by customers.

PACKAGE: SYS.OWA_TEXT 12.2.2
owner:SYS, object_type:PACKAGE, object_name:OWA_TEXT, status:VALID,
PACKAGE: OWAPUB.OWA_TEXT 12.1.1
owner:OWAPUB, object_type:PACKAGE, object_name:OWA_TEXT, status:VALID,
PACKAGE BODY: SYS.OWA_TEXT 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:OWA_TEXT, status:VALID,
PACKAGE: SYS.OWA_TEXT 12.1.1
owner:SYS, object_type:PACKAGE, object_name:OWA_TEXT, status:VALID,
PACKAGE BODY: SYS.OWA_TEXT 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:OWA_TEXT, status:VALID,
SYNONYM: PUBLIC.OWA_TEXT 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:OWA_TEXT, status:VALID,
SYNONYM: PUBLIC.OWA_TEXT 12.1.1
owner:PUBLIC, object_type:SYNONYM, object_name:OWA_TEXT, status:VALID,
PACKAGE BODY: OWAPUB.OWA_TEXT 12.1.1
owner:OWAPUB, object_type:PACKAGE BODY, object_name:OWA_TEXT, status:VALID,
PACKAGE: SYS.OWA_TEXT 12.1.1
PACKAGE: SYS.OWA_PATTERN 12.2.2
owner:SYS, object_type:PACKAGE, object_name:OWA_PATTERN, status:VALID,
PACKAGE BODY: OWAPUB.OWA_PATTERN 12.1.1
owner:OWAPUB, object_type:PACKAGE BODY, object_name:OWA_PATTERN, status:VALID,
PACKAGE BODY: SYS.OWA_PATTERN 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:OWA_PATTERN, status:VALID,
PACKAGE: SYS.OWA_TEXT 12.2.2
PACKAGE: OWAPUB.HTP 12.1.1
owner:OWAPUB, object_type:PACKAGE, object_name:HTP, status:VALID,
12.1.1 DBA Data 12.1.1
12.1.1 DBA Data 12.1.1
PACKAGE: OWAPUB.OWA_PATTERN 12.1.1
owner:OWAPUB, object_type:PACKAGE, object_name:OWA_PATTERN, status:VALID,
PACKAGE: OWAPUB.OWA_TEXT 12.1.1
PACKAGE: SYS.OWA_PATTERN 12.1.1
owner:SYS, object_type:PACKAGE, object_name:OWA_PATTERN, status:VALID,
PACKAGE BODY: SYS.OWA_PATTERN 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:OWA_PATTERN, status:VALID,
PACKAGE: SYS.HTP 12.1.1
owner:SYS, object_type:PACKAGE, object_name:HTP, status:VALID,
PACKAGE: SYS.HTP 12.2.2
owner:SYS, object_type:PACKAGE, object_name:HTP, status:VALID,
PACKAGE BODY: SYS.OWA_TEXT 12.2.2
PACKAGE BODY: OWAPUB.OWA_TEXT 12.1.1
PACKAGE BODY: SYS.OWA_TEXT 12.1.1
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.1.1 DBA Data 12.1.1
PUBLIC.OWA_TEXT dependencies on OWA_TEXT 12.2.2
OWAPUB.OWA_PATTERN dependencies on OWA_TEXT 12.1.1
SYS.OWA_PATTERN dependencies on OWA_TEXT 12.2.2
SYS.OWA_TEXT dependencies on OWA_TEXT 12.1.1
SYS.OWA_TEXT dependencies on OWA_TEXT 12.2.2
PUBLIC.OWA_TEXT dependencies on OWA_TEXT 12.1.1
SYS.OWA_PATTERN dependencies on OWA_TEXT 12.2.2
SYS.OWA_PATTERN dependencies on OWA_TEXT 12.1.1
OWAPUB.OWA_TEXT dependencies on OWA_TEXT 12.1.1
SYS.OWA_PATTERN dependencies on OWA_TEXT 12.1.1
OWAPUB.OWA_PATTERN dependencies on OWA_TEXT 12.1.1
PACKAGE: SYS.DBMS_STANDARD 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_STANDARD, status:VALID,
PACKAGE: SYS.DBMS_STANDARD 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_STANDARD, status:VALID,
PACKAGE: SYS.STANDARD 12.1.1
owner:SYS, object_type:PACKAGE, object_name:STANDARD, status:VALID,