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!

Invalid use of ampersand ('&')

602683Oct 11 2007 — edited Oct 11 2007

I have some PL/SQL code that uses XMLELEMENT/XMLFOREST etc functions to create XML documents. The code works as intended on PA-RISC and Intel Itanium based platforms. However, when the code is run on Linux, I get errors similar to :

ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00242: invalid use of ampersand ('&') character (use &)
Error at line 22755
ORA-06512: at "SYS.XMLTYPE", line 254

The code is fairly complex, using nested tables with CAST and MULTISET. I have tried to create a simple test case where the problem happens, but I have had no luck so far.

I was wondering if anyone else has encountered this problem and if so, if there was a simple workaround/bug fix.

Oracle RDBMS 10.2.0
Oracle Enterprise Linux 4.5

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 8 2007

Added on Oct 11 2007

#performance-availability, #xml-db

1 comment

787 views