Search Results match_pattern

Overview

OWA_MATCH is a SYS-owned PL/SQL package shipped as part of the Oracle Web Agent (OWA) toolkit embedded within the Oracle E-Business Suite technology stack. It is present and valid in both EBS 12.1.1 and 12.2.2. The package provides low-level pattern matching utilities used by the Oracle HTTP Server PL/SQL gateway and by other OWA packages that must evaluate string patterns against input text. In the EBS context, OWA_MATCH supports the presentation and web-serving layers rather than any specific Oracle Applications business module, and it is classified in ETRM under the generic API category OTHER.

During the 12.1.1 to 12.2.2 upgrade, the OWA toolkit is retained because the EBS middle tier, Oracle Application Framework pages, and various self-service and administrator JSP/PLSQL components still depend on the OWA_* plumbing for URL handling, CGI processing, and text manipulation.

Key Procedures and Functions

The ETRM 12.2.2 metadata documents one callable entry point in this package:

• MATCH_PATTERN — Evaluates a supplied pattern against a target string and reports whether (or to what degree) they match. This is the core utility of the package and the routine on which external code would rely when performing OWA-style pattern comparison. Parameter lists are not enumerated here; consumers should reference the installed package specification in the SYS schema for the exact signature, as ETRM does not publish the argument definitions.

No other procedures or functions are documented for OWA_MATCH. The package body may contain private helpers supporting MATCH_PATTERN, but these are not exposed as documented APIs.

Tables Accessed

The ETRM dependency extract for SYS.OWA_MATCH lists no base tables accessed via APPS synonyms. This is consistent with the package's role as a stateless string-processing utility: it operates entirely on in-memory PL/SQL variables and does not perform DML against EBS application tables. All inputs are passed as parameters by the calling program, and all outputs are returned to that caller. Consequently, OWA_MATCH has no transactional footprint, does not participate in the EBS data model, and cannot be audited through table-level triggers.

The only referenced objects are other SYS-supplied constructs: SYS.OWA_UTIL, which supplies shared OWA helper routines, and the STANDARD package, which provides the base PL/SQL runtime definitions. These dependencies confirm the package is a low-level utility layered on the Oracle Web Agent infrastructure.

Usage Notes

OWA_MATCH is referenced by PUBLIC.OWA_MATCH and SYS.OWA_MATCH, indicating that a public synonym exposes the package and that the SYS-owned definition is the authoritative implementation. ETRM records that it is referenced by zero other packages, so direct dependencies from EBS application code are not registered in the standard metadata; in practice, any invocation occurs through dynamic or indirect calls from the OWA layer or custom code that explicitly relies on the public synonym.

The package is not exposed through a standard EBS form, concurrent program, or profile-driven feature. It is invoked programmatically, typically from custom PL/SQL that requires OWA-style pattern matching, from the mod_plsql gateway processing chain, or from diagnostics and patching routines that validate the integrity of the OWA toolkit. Because it is a SYS-owned dictionary object, direct modification is unsupported; custom development should treat it as read-only infrastructure and should prefer documented, APPS-owned alternatives where pattern matching is required in a business context.