Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links

Comments

Parse XML Documents - Explode unstructured XML documents into relational tables using the new integrated XDB packages.



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

Thx
Grace.

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.

Cheers

Tim...

Aparna said...

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

San said...

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

Pranitha said...

I used the same example given in the link http://www.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
http://www.oracle-base.com/forums/viewtopic.p

pranitha said...

sorry the link is
http://www.oracle-base.com/forums/viewtopic.php?f=2&t=11579&p=32316#p32316

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...

Hi.

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.

Cheers

Tim...

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!

Add your comments here.
Name
Comment
(max 400 chars - plain text)