Following database 19.20 patching XML fails to parse when returning from a pl/sql function into SQL
-- Trace File --
File Name or Source
-------------------------
Fail_19_20.tx
Description
--------------
SQL> select banner_full
2 from v$version;
BANNER_FULL
----------------------------------------------------------------------------------------------------------------------------------------------------------------
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.20.0.0.0
SQL>
SQL> create or replace view test_xml_view
2 as
3 select xmlforest(xmlconcat(xmlelement("lims:name",'Trap location'),xmlelement("lims:value"
4 ,case when dummy = 'X' then 'true' else 'false' end
5 )) as "lims:propertySet"
6 ,xmlconcat(xmlelement("lims:name",'Trap model'),xmlelement("lims:value"
7 ,case when dummy = 'X' then 'true' else 'false' end
8 )) as "lims:propertySet"
9 ) properties_x
10 from dual
11 /
View TEST_XML_VIEW created.
SQL>
SQL> create or replace function test_xml_func