Jump to content

Search the Community

Showing results for tags 'xml'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Oracle
    • Oracle Forum

Calendars

  • Community Calendar

Found 1 result

  1. Hi, I have a program working with xml files that is not performing anymore since we installed Oracle 12 databases. The error we suddenly have is this one : ORA-31011: XML parsing failed ORA-06512: at "MYUSER.MYPACKAGE", line 1663 ORA-19213: error occurred in XML processing at lines 2 LPX-00209: PI names starting with XML are reserved ORA-06512: at "SYS.XMLTYPE", line 272 ORA-06512: at "MYUSER.MYPACKAGE", line 1162 ORA-06512: at line 1 It seems there is a problem on line 2 of the xml. Indeed this file is particular. There is an xml declaration on each line and lines are pretty long, defining several xml blocks : <?xml version="1.0" encoding="utf-8"?><Flag:...... <?xml version="1.0" encoding="utf-8"?><Message:...... <?xml version="1.0" encoding="utf-8"?><Message:...... ..... <?xml version="1.0" encoding="utf-8"?><Message:...... <?xml version="1.0" encoding="utf-8"?><EndFile:...... In the program the first thing done is to create a blob file from this xml file (this is a function called at the beginning : FUNCTION TransformToCLOB(filename varchar2) RETURN CLOB) src_clob:=BFILENAME('MY_REPERTOIRE', filename); dbms_lob.createtemporary(dest_clob, cache=>TRUE); DBMS_LOB.FILEOPEN(src_clob); DBMS_LOB.LoadFromFile( dest_clob , src_clob ,DBMS_LOB.GETLENGTH(src_clob) ); dbms_lob.close(src_clob); RETURN dest_clob; after that, there is this instruction (ligne 1162 where the error occurs): v_xml:=XMLTYPE(dest_clob); What has changed in Oracle 12 that causes the problem? I have the feeling that several declarations in one file are not welcome anymore.
×