The DBMS_XMLGEN system package converts the results of SQL queries into a standard XML format and returns the results as CLOB data.
Applicability
This content applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL-compatible mode.
DBMS_XMLGEN Privileges
The EXECUTE privilege on the DBMS_XMLGEN package is granted to PUBLIC. The current user has the privilege to use the subprograms within this package.
Overview of DBMS_XMLGEN Subprograms
The following table lists the DBMS_XMLGEN subprograms supported by the current version of OceanBase Database and provides brief descriptions.
subprogram |
Description |
|---|---|
| CONVERT | Converts XML data to its escaped or unescaped XML equivalent. |