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...
Prepared Statement Error: Table './oraclebasecms/cms_page_comment_uuids' is marked as crashed and should be repaired