3 Replies Latest reply: Jan 28, 2014 1:27 AM by 1016450 RSS

    Error LPX-00210

    64ab2685-c0d2-4ce3-96ec-86c33f5a3b3b

      SET SERVEROUTPUT ON

       

       

      DECLARE

      xml_handle       DBMS_XMLSTORE.ctxtype;

      f                BFILE;

      number_of_rows   NUMBER;

      xml_data         CLOB;

      BEGIN

      f := BFILENAME ('XMLTEST', 'sample.xml');

       

       

      DBMS_LOB.createtemporary (xml_data, TRUE, DBMS_LOB.SESSION);

       

       

      DBMS_LOB.fileopen (f, DBMS_LOB.file_readonly);

      DBMS_LOB.loadfromfile (xml_data, f, DBMS_LOB.getlength (f));

      DBMS_LOB.fileclose (f);

       

       

      xml_handle := DBMS_XMLSTORE.newcontext ('EMPFROMXML');

      DBMS_XMLSTORE.setrowtag (xml_handle, 'EMPLOYEE');

      number_of_rows := DBMS_XMLSTORE.insertxml (xml_handle, xml_data);

       

       

      DBMS_OUTPUT.PUT_LINE( number_of_rows || ' rows inserted.' );

      DBMS_XMLSTORE.closecontext (xml_handle);

      DBMS_LOB.freetemporary (xml_data);

      COMMIT;

      END;

      /

       

      error ..

       

      ORA-31011: XML 구문 분석을 실패함

      ORA-19202: XML 처리

      LPX-00210: ' ' 대신 '<'이(가) 필요함 중 오류가 발생했습니다.

      ORA-06512: "SYS.DBMS_XMLSTORE",  78행

      ORA-06512:  17행

      31011. 00000 -  "XML parsing failed"

      *Cause:    XML parser returned an error while trying to parse the document.

      *Action:   Check if the document to be parsed is valid.

       

       

       

      NLS_LANGUAGE AMERICAN

      NLS_TERRITORY AMERICA

      NLS_CURRENCY $

      NLS_ISO_CURRENCY AMERICA

      NLS_NUMERIC_CHARACTERS .,

      NLS_CHARACTERSET KO16MSWIN949

      NLS_CALENDAR GREGORIAN

      NLS_DATE_FORMAT DD-MON-RR

      NLS_DATE_LANGUAGE AMERICAN

      NLS_SORT BINARY

      NLS_TIME_FORMAT HH.MI.SSXFF AM

      NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM

      NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR

      NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR

      NLS_DUAL_CURRENCY $

      NLS_COMP BINARY

      NLS_LENGTH_SEMANTICS BYTE

      NLS_NCHAR_CONV_EXCP FALSE

      NLS_NCHAR_CHARACTERSET AL16UTF16

      NLS_RDBMS_VERSION 11.2.0.1.0

       

      Oracle Database 11g Release 11.2.0.1.0 - 64bit Production

      PL/SQL Release 11.2.0.1.0 - Production

      "CORE 11.2.0.1.0 Production"

      TNS for 64-bit Windows: Version 11.2.0.1.0 - Production

      NLSRTL Version 11.2.0.1.0 - Production

       

       

       

       

       

      why?