The DBMS_XMLGEN package converts the SQL query result into the standard XML format and returns the result as a CLOB.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Privileges
The EXECUTE privilege on the DBMS_XMLGEN package is granted to PUBLIC. Subprograms in this package are executed with the privileges of the current user.
Subprograms
The following table describes the DBMS_XMLGEN subprograms supported by the current OceanBase Database version.
| Subprogram | Description |
|---|---|
| CONVERT | Converts XML data into escaped or unescaped XML equivalents. |