My Oracle Support Banner

Missing Empty XML tag in 12.1.0.2.190416 PSU (Doc ID 2635142.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

An empty XML tag is missing in the latest 12.1.0.2.190416 PSU.

Select
XMLELEMENT("TEXT2",
XMLFOREST(to_char(current_timestamp ,'YYMMDDHH24MISS')||
LPAD(<SEQUENCE_NAME>.nextval,7,'0') as "ID") as "ID",
XMLELEMENT("<COLUMN1>",
XMLFOREST('<NAME>' AS "Name",
'' AS "TEXT3")AS "Control block"
) as "Data"
) "TEXT2"
from DUAL ;


<TEXT2>
<ID>1234</ID>
<TEXT1>
<Name>NAME</Name>
</TEXT1>
</TEXT2>

The Tag <TEXT3/> is missing.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.