ORA-31011 and LPX-00244 with ampersand in XML-attribute after upgrade on Oracle 11.2.0.2.0
Hi,
After upgrade on Oracle 11.2.0.2.0 we got the Error ('' is two single quotes, not a double quote)
----------------------------------------------------------------
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.2.0
Connected as pt1
SQL> select XMLTYPE('<TEST><PK nn='''SCOTT''/></TEST>') AS XML_TEST FROM dual;
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00244: invalid use of less-than ('<') character (use <)
Error at line 1
ORA-06512: at "SYS.XMLTYPE", line 310
ORA-06512: at line 1
but with blank between ' and & i get no error:
-----------------------------------------------------------------
SQL> select XMLTYPE('<TEST><PK nn='' 'SCOTT''/></TEST>') AS XML_TEST FROM dual;
After upgrade on Oracle 11.2.0.2.0 we got the Error ('' is two single quotes, not a double quote)
----------------------------------------------------------------
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.2.0
Connected as pt1
SQL> select XMLTYPE('<TEST><PK nn='''SCOTT''/></TEST>') AS XML_TEST FROM dual;
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00244: invalid use of less-than ('<') character (use <)
Error at line 1
ORA-06512: at "SYS.XMLTYPE", line 310
ORA-06512: at line 1
but with blank between ' and & i get no error:
-----------------------------------------------------------------
SQL> select XMLTYPE('<TEST><PK nn='' 'SCOTT''/></TEST>') AS XML_TEST FROM dual;
0