8 Replies Latest reply: Apr 30, 2007 3:28 PM by mdrake-Oracle RSS

    ORA-31011: XML parsing failed

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