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

DO NOT ask technical questions here, that's what my forum is for!

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)