8i | 9i | 10g | 11g | 12c | Misc | PL/SQL | SQL | RAC | Linux

Home » Misc » Here

Comments for Parse XML Documents

Grace said...

I ma getting the following error while running this procduere. please suggest..

ERROR at line 1:
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00210: expected '<' instead of 'E'
Error at line 1
ORA-06512: at "XDB.DBMS_XMLPARSER", line 190
ORA-06512: at line 32


Tim... said...

Please ask questions in the forum, not in the comments.

It looks like you have a mistake in your XML document.

If you need any more help post your question on the forum.



Aparna said...

This is an excellent example!
Was really helpful for a newbie like me.

San said...

nicely explained. saved lot of my time. :-D

Pranitha said...

I used the same example given in the link https://oracle-base.com/articles/9i/ParseXMLDocuments9i.php
And I replaced the '/EMPLOYEES/EMP' with '/' then it is not giving me any errors but it is inserting null values into the table and it is parsing through the loop only once.Am I missing something here?I posted a question on the forum too

pranitha said...

sorry the link is

Rasheed said...

After successful installed apex, my browser load but not display anything. What I only see is http://localhost:8080/apex/f?p=4550:10:17212012326389

ERROR at line 1:
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00200: could not convert from encoding UTF-8 to WINDOWS-1252
Error at line 1
ORA-06512: at line 26
ORA-06512: at line 59

Tim... said...


APEX hasn't got anything to do with this article. :)

It looks like a character set issue to me. I guess you should be using UTF8 on your database, not an APEX guy though.

I suggest you post this question on the APEX forums at OTN.



DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!