LPX-00209: PI names starting with XML are reserved when parsing an XML file
(Doc ID 2274432.1)
Last updated on APRIL 12, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterOracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
On : 12.1.0.2 version, XML Database
When attempting to run
SQL>declare
2 lv_result CLOB;
3 ss ms2003_ssdoc_typ;
4 lv_select1 VARCHAR2(32000);
5 cur SYS_REFCURSOR;
6
7 BEGIN
8 lv_select1 := 'SELECT c.polis_nr
9 ,p.prod_cd
10 ,c.dt_einde
11 ,hn.nr insz
12 ,n.naam
13 ,n.voornaam
14 ,a.straat || '' '' || a.huis_nr || '' '' || a.bus_nr adres
15 ,d.post_cd pkgm
16 ,d.oms wopl
17 ,le.lpbn_hfd_cat_cd
18 ,le.lpbn_sub_cat_cd
19 ,le.dt_gldg_begin
20 ,le.dt_vanaf
21 ,le.dt_tot
22 ,le.dt_ondertek
23 ,le.dt_binnenkomst
24 FROM tag_hist_nr hn
25 ,tag_naam n
26 ,tag_adres a
27 ,tag_adres_partij ap
28 ,tag_dlgmt d
29 ,ovmb.tzs_lpbn_eff_ven le
30 ,tvz_partij_con pc
31 ,tvz_con c
32 ,tvz_prod p
33 WHERE hn.partij_id = pc.partij_id
34 AND hn.type_nr_cd = ''0''
35 AND hn.dt_tot IS NULL
36 AND n.partij_id = pc.partij_id
37 AND n.type_naam_cd = ''OFF''
38 AND n.dt_gldg_einde IS NULL
39 AND ap.type_adres_cd = ''OFF''
40 AND ap.dt_gldg_einde IS NULL
41 AND ap.partij_id = pc.partij_id
42 AND a.id = ap.adres_id
43 AND a.dlgmt_id = d.id
44 AND le.lid_partij_id = pc.partij_id
45 AND le.lpbn_hfd_cat_cd IN (''GLS'', ''AGLS'', ''MWES'')
46 AND le.lpbn_sub_cat_cd IN (''ZKT'', ''GLSZKT'', ''AGLSZKT'')
47 AND le.dt_gldg_einde IS NULL
48 AND pc.rol_cd = ''1''
49 AND c.id = pc.con_id
50 AND c.dt_gldg_einde IS NULL
51 AND p.id = c.prod_id
52 AND p.prod_hfd_groep_cd IN (''4'', ''5'')
53 ORDER BY le.dt_vanaf
54 ,c.polis_nr';
55
56 ss := ms2003_ssdoc_typ();
57
58 OPEN cur FOR lv_select1;
59 ss.add_worksheet(cur, NULL, 'Lijst GLS');
60 CLOSE cur;
61
62 lv_result := ss.create_xml_clob();
63
64 lv_result := ss.create_xml_clob();
65 exception when others then
66 dbms_output.put_line('error : '||sqlerrm);
ERROR
-----------------------
The following error occurs:
DECLARE
*
ERROR at line 1:
ORA-31011: XML parsing failed
ORA-19213: error occurred in XML processing at lines 27
LPX-00209: PI names starting with XML are reserved
ORA-06512: at "OVMB.PAP_XML_01", line 909
ORA-06512: at "OVMB.MS2003_SSDOC_TYP", line 211
ORA-06512: at "OVMB.MS2003_SSDOC_TYP", line 223
ORA-06512: at "OVMB.PAP_T041_LIJST_GLS", line 263
ORA-06512: at line 18
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 |
| Cause |
| Solution |