Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-31011: XML parsing failed

495123Apr 30 2007 — edited Apr 30 2007

I believe this is correct syntax:

SELECT XMLELEMENT("stuff", DUMMY) FROM dual

However, I get the ORA error in Toad 9.0.1.8 and SQL*Plus 9.2.0.1.0 on Oracle DB 10.2.0.2.0 upon execution. Toad also locks up.

I wrote and ran many XML queries on Friday, but now anything new I write crashes. I have a multi-element select written Friday that runs, but if I make any alteration, it errors.

The DBA doesn't know of any changes made to the database. I've also tried another environment with the same results.

Any suggestions?
Thank you.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 28 2007

Added on Apr 30 2007

#performance-availability, #xml-db

8 comments

2,898 views