7 Replies Latest reply: Dec 28, 2012 3:57 AM by AlexAnd RSS

    XML data to Oracle Table

    San
      Hi,

      Can ayone help me out to load the below XML data into Oracle Table
      <?xml version="1.0"  encoding="UTF-8"?>
      <DEMOGRAPHIC_DETAIL>
      <ROW>
      <APP_UPDTFLG>01</APP_UPDTFLG>
      <APP_INT_CODE>SUNDBNP</APP_INT_CODE>
      <APP_TYPE>I</APP_TYPE>
      <APP_NO/>
      <APP_DATE/>
      <APP_PAN_NO>ANCPB3518P</APP_PAN_NO>
      <APP_PANEX_NO>NA</APP_PANEX_NO>
      <APP_PAN_COPY/>
      <APP_EXMT/>
      <APP_EXMT_CAT/>
      <APP_EXMT_ID_PROOF/>
      <APP_IPV_FLAG/>
      <APP_IPV_DATE/>
      <APP_GEN/>
      <APP_NAME>GODAVARI V BARBIND</APP_NAME>
      <APP_F_NAME/>
      <APP_REGNO/>
      <APP_DOB_DT/>
      <APP_DOI_DT>NA</APP_DOI_DT>
      <APP_COMMENCE_DT/>
      <APP_NATIONALITY/>
      <APP_OTH_NATIONALITY/>
      <APP_COMP_STATUS/>
      <APP_OTH_COMP_STATUS/>
      <APP_RES_STATUS/>
      <APP_RES_STATUS_PROOF/>
      <APP_UID_NO/>
      <APP_COR_ADD1/>
      <APP_COR_ADD2/>
      <APP_COR_ADD3/>
      <APP_COR_CITY/>
      <APP_COR_PINCD/>
      <APP_COR_STATE/>
      <APP_COR_CTRY/>
      <APP_OFF_NO/>
      <APP_RES_NO/>
      <APP_MOB_NO/>
      <APP_FAX_NO/>
      <APP_EMAIL/>
      <APP_COR_ADD_PROOF/>
      <APP_COR_ADD_REF/>
      <APP_COR_ADD_DT/>
      <APP_PER_ADD1/>
      <APP_PER_ADD2/>
      <APP_PER_ADD3/>
      <APP_PER_CITY/>
      <APP_PER_PINCD/>
      <APP_PER_STATE/>
      <APP_PER_CTRY/>
      <APP_PER_ADD_PROOF/>
      <APP_PER_ADD_REF/>
      <APP_PER_ADD_DT/>
      <APP_INCOME/>
      <APP_OCC/>
      <APP_OTH_OCC/>
      <APP_POL_CONN/>
      <APP_DOC_PROOF/>
      <APP_INTERNAL_REF>NA</APP_INTERNAL_REF>
      <APP_BRANCH_CODE>NA</APP_BRANCH_CODE>
      <APP_MAR_STATUS/>
      <APP_NETWRTH/>
      <APP_NETWORTH_DT/>
      <APP_INCORP_PLC/>
      <APP_OTHERINFO/>
      <APP_FILLER1/>
      <APP_FILLER2/>
      <APP_FILLER3/>
      <APP_STATUS>02</APP_STATUS>
      <APP_STATUSDT/>
      <APP_ERROR_DESC/>
      <APP_DUMP_TYPE/>
      <APP_DNLDDT/>
      <APP_KRA_INFO>NDML</APP_KRA_INFO>
      <APP_SIGNATURE>SUkqAAgAAAASAP4ABAABAAAAAAAAAAABAwABAAAAkwEAAAEBAwABAAAAkwEAAAIBAwABAAAAAQAAAAMBAwABAAAABAAAAAYBAwABAAAAAAAAAAoBAwABAAAAAQAAABEBBAABAAAAMwEAABIBAwABAAAAAQAAABUBAwABAAAAAQAAABYBAwABAAAAkwEAABcBBAABAAAAgxIAABoBBQABAAAA5gAAABsBBQABAAAA7gAAACUBBAABAAAAAAAAACgBAwABAAAAAgAAADEBAgAZAAAA9gAAAKaABAAJAAAADwEAAAAAAACWAAAAAQAAAJYAAAABAAAAT2kvR0ZTLCB3cml0ZXIgdjAwLjA2LjAyAFdBTkcBAAAABQAAAEzEAQCuwQAAruEAALyBAQAgogEA3K4BAC5GMj5fLstwNEp4d6EtxVDJrluSqPzqi/9y/xBqygMpbKqj9/EkLGddSRl6y/kuiOiP8zROgRT/0iP7ibUxF/MIIJlei6YLM8QZTqvfoEC1HjX4l0F4PIxY/4IFz1j+ggXgvGuNA6BBcwjyX6/x4///ggTBQds65MkPv37BcNwt15XdEcMyCLo1owirWDdh2LCK40y5cilvvRXMIjgyCLKCBTIXBlI4iPsSKs+/MkAridiqGZDhsMISJo2p2MRQCoOyhUiQKRHFLcfEZIA4EyWAgzAFzBmIySkfR4j0eje1BGXg3EoI7qvqDBTIpZ4fcP1X+ZIMwMEHSczuaPoxwRHofzsTR/NhCPHMFqaMF7//vBAr87qIwwq/ot8FTff//3/yaGYwv3/Xq3keR464XvV+/hbRcfs9/8HXGtxxX/f/nnob0CI///1/X/HsH/S+r/wvfPqObjT9rvndousHSRg4IE9L/sjuC/v+mGCKc198rPrYf3xD/+n3X/kY9g6fzJw3/+F/r+R+K0bn+70+MG7sH9C/+4v/3gs7FVfft7u0v6cYVOInY2ZzLog19v3mzx7U8lkEXQQIfkyF4renoGg4mRkvEdU1XRXLewi3J8S35PZXlbHFKPk2LqTZCN4SlIijwRTxNFJqsEC2hyPcui+eIj4ILQQXJsVhvpIIupThBfBlYy3F/sGD+PluBoTV+UP4MutAjaxIz/BcMGFrlQn/l15fBKGW4oj6PpIvl48h4OGsS3KVhBYPs4pk2qXePJuMDeTbXkYgytjkPUfn8zRH5NV5HQIF7luBIzi6Lojo+sMui6wb6EtxtIG5fSM/etkdBAvBlWZuNy6gqxXBBWoQX/4TCZxwgonEJ7g/w//MfWX88lqCBftcGCChwy3ElqLWo7BwfYXRbguY0iO4ZtbyuXhqNL5XUGLBEdmEpH5kUIFOypIL0EJ/2RQF8QfZ7OL5MUI0Wdcd3kwtUEChTiWxGR0tk7QnrhFDhdEdCXXNo+iOyOs5m12jDpWhCjewgvf6BAvlDh7SQmeIZir74QXwgvMh5KwghCBZOgutsXHfwsYQVY//cGVsz6STKg9r7qCkewp3NLBnIjBRFcGdgS08UFzsS1JRaQIEdrKcvnXppBNGcQiDF0suhpqTB6sEECO1tEQlzj6tGeggylCz2ew0UKlqjvoKEhIwQyToQguukcGrdRSBZ7xlCIRb4SVg6KsQyvLkEkECUx5dHv9IJXBEci+VAmwSCLoeIQXDy6DLVeEJgnoQQJwgQl9WcMqyhMul8IF5u/hKtAgRVzQZ3hlITON4S/1EEUt9BaCEpxEhMIRCC8um/CCC/835ieIKDBKvEEC2VGFCC/hKD3lK4RRNAiEE1Z/Bn6SwN7hnYNJcIpxR+lidpBc0lQJxSrWg1BE5Kp0BDW40CJh25H6ZsFBcKNC1PaFE7SHotyCD3EyUIzUIFkdF4j5fNojoj5H4kXidLZkSryM4IL4Yjv5cf44+DzNAvkfYpLx1BAuY8fDKMyKGE4mEbX/wgsEU9+XUh2bUwL/1socFqDultj/BoLbBDIkBCNhHYoBBXKkUcZ3I3BFcvm7eTY/jwQIRuI5Qi+bRiOIui3FkXR5HlWHfpEe/U1qXRdDBArYggUPxSI6BAsxl9YQWpj/+EX8xEDXa/CBfg45Tr//9wiPYI486JIuh/fwbDfEp0LKBPfEQ5NlMN/EeDSluqZ0XSLcpxOK6QuR1jJsdFHnEeUmuSEGVhUIUvmECBQzER0bz6I/4mEoIId4IFwkCC4QKlLcbynSYZRYP/39V/wfC1s1wZ9KjJq/4QL7iYQn4M8BkfwQXBBf6jai4bL8HaaEOJbpS+CBE2ToM6mTYYglBlJbOtiVCkxluF/N+R0XzfRqh5fM2XvDKcIjoTi5NfQRdA/WCBYluUVgiiVv8jr/8GCHv8PD/4j/8EC7wf9wuD8KW6qjNfb2nEt1pF18m2YOJjk2qWJ9QgsfDLoxkfGGGIZRKHGVGbRmiOhnVG0F9lNxYqCoKs6qTW+ER1iW42gQX4zqv/h6yPAgX/iH0ER8jFheHvGHnRXy6FnyJbrSyP+e8MS3S7JmG4cm19AzCChUm08MrvEUCMZtDH5AkRMy3xCJmjyggvSSZQl2YjalRI6HGfzioYQW+zaMI2jCK6r/zy99fXxMI6IT6///p4dnIggV1vEfBwgQXK6xEfFIv6xwQJIzRuKT9c30JjOzUNze77/7t6ybJ0dET8WUFk2MJelJtMxHBFQpIRdEdGrPIS6zl/Lo8i6CBPluBGXjOZVhQQLD/+W4rh2gQVpfB8Pnl/Bp8fCC/4bKJTaCCza//ETaHeyrBBnuW6zn62TZXxGTY6KTpEvDEwvoKDKIyYyhLz+Xj3l0EEym4rGR4IE6CI+Ev8M+zUcP4IF/0RRf9Ba4kvl80xPrkewgX4v++V1lH1jG+vBBeR7xOLMS+U6w4YMorm0wWDKbjFI9BUP+XMtx/iP4LwWJ7nZrrKf6l8fQPuVyRBiDwx30piUm1ECKShP7OtFuZDNpITyJ+W6RmIjg0dby3EAujFR9CtDiRXFgVxxqV6gZxGZLILB7O1NTIgFQ4x52aA1CZBxmhnY0CqOS/OzUDxjzUCwW50RCGbDaCQSk1AxjlmxDjBH+IybIyPkT7Z9FQh0Ys5n9Y6oIRtDyoRxFuWIKR0CBDwkcPDdkRyINBZNiwN35T7spuqlbH0yPluUdnlhcjbib2eDqeEUPgjawgWNQnYW1BlPwkXUPSUER9WFoLI9DUbHDxB4Khh6JCHcIjotxv/PIhrKHyoM9lNxdilB+Gr4mEI//CRmoYIFoEC1/4gwZbiqBlGWNedVCluqLzV88xBAhM0kMSP6spUJeEtwTxuToUEcRtHkf6CLrN5biSGGysj2agJvcfh/JsVBuIQXjBAohkd5brMaIwvCC5bquP4wwi3U0JmjCBo4sqozcqnEYXDTZwLPYIodFuJIYMEgRUYfZQ535biyLoHDbe3aLdUTKfuPKMT6F8EU4LnMECbX9KEiPcYQQtj6C4k8YVa4giPDjiJnYnlZhyhwyOy3FtlC9K9EdiyuOBQdIJS3LEPqwXZQF/whPodAinSWkQnax4RhCPsYeW4uiQjr/BAgQbKRGkGUOLEEi6NaI/BguRxLcVoXvsQ9UkJvB7YdRSBAhSkIsHzCojobKgOCI+P3DCBAvERJ+COOEHxvmAQm38OiKPLcWR1QwX/tgwQOnwfxE4jHES3Ukb8TCkxGyBBY4WQm8p4cRuIP8N3zeXIMo2KbQ8txNEZ/LcXX6MIQZwSGRzI9luFojqzaoocKEFoF8fD/B8Gfgr/EHhQgT0McMQ4QLs9yPHFKtc0S3Glg7wYX6D8zTKiE4IukCPKqFkfEL6DdWaP8IEdcjnYjoI44NBEdGMwgYXQiSeW41YNBIjqhOLGCPlIObL4QLBAulR4pS3A0SEQ8EC/vtQz0y3Tojoj5HWR0bwQKTgryvfEXpkdZHRHwnK4TIhEfJzNiBBfTUN2UPxBAoc44g4ftsIjqVx0XR6LikdEd9nNMLB7YeD7EPZHRcWcd/BjMipHESJhQcTjrsjxdF0EN9ncPs+8NWfgsRN2CfR7KEjIPI6I6PmXRdBQgnQ+ECDQKDZ3RhQzYPBL7rCiTHwYhxnamiIN+NbwguSH+7GEOMKoQeX9Rsuh2DDm0cTzsTjiMaR5BFDhcGRwlx+oZ4chmQIhyQ41UJh0gpxlzI/KHwiOgSUZWUXyOiOiMzyD7iyoPlsIJ5nSBAp+kFWzQewQIWRw2KFLiCih9a4S5GOpE0XRdGDMMGxzHhxBleFopxoPLrkNNy3RHWggiHHx0sIjovMLkMYVYZOpqRpwaTjm8wjPTfBJnmvhXcIIocIE4hwa844Mj4Y4whBAhIS+gRjWXMECzaEEsKX0128HCmEeaDQgy5kdoEGCYqQ1RwchjDjk36EEXX5H8RCWCLm6ReRQ4Ijg6l0R89l2RxC6BHHYIEzDwiIPwRx3GoISDA+RR7Cj0uRByx6zOEC62IcjxfxqunLHH/C4jv+4Ij7Eerow+CBOLBYwTI/SDjZx65PkqDcIodweFCKHCC/lzuZx3/9yKOYcEF5DQOIaCkIORXBp0DCg+CBYIjlwhHBl8Jl8j+wgsWk0EccIjoPbJPiPggWvqIhkcNBHAunSdQaUf844hAgfQRHCR8g0W1iOcc7iHBqecgeMcRshlDlDiJDEA/sjx5wR7w30JBuP0NcNIZcDBeI4HhQTRMcSn8EF7/Loh+IhBkGB2RxIMjhnLhtyHHM9YizYF4gweGoZ4qbi6yPm7IVybhrHhiQwP5A8FoeCJjkEgg0VhggRKA3uuOOQ0DqJIcm5BXHIaTkI5xyY4QVlQq5NwzCZrB5Ff0EQUDnsJEHcijkO6RBi0F5GOQXH+tcX7cJncmOScr4fPIzjaLi4d/DzwSkGC4I4+I64nHBxyDSOiOEI6RQ4TO4IS6MQSI7Yx3FSBEbiGRwMSBI4jZBByK5EfEScGgR3FqvpWy7OXiGRwMAoMSGcfIOOZyDcfKHIKB9TvhAsSGwcQ+IhCNUoccgQ48IhlDkY+LWwyn0jveKiQXfCRG5nIjgyOzCI6EHI6H+iQ8NLYSRQ5bhAynIFY4kUcRIsDtluJh+FyGpTsnWpAu+DI8GQo8I95Cjsjg0KCBcSY5IdIg44RHB07eUPg7PrBhF15Dj5Bgeh2i3SEfEGCBayBIP+dwQVpFuEEyPRPfrwzU2Y10msQvlPkbjkMx6xEgYcp2R0XYRDVHFcaXsKRZqxccUhBEfQIEIYWCBNmctxrGhJjhp/KcaSV4TI/l0Pkx/fDBe70QwOQLjiSHxxDI5kcFyOICUkO9EUfJjqgjwkFKHLrMOVxxfkbwyBd//8ciupBB0sSTiQrmcqLSSQQnH6FRSBtQ9oj6Cx8aGGGid5B3yxxEkOFCCBkcYXmHPAUGvEw4qLI4ka0R8EED5HR5IIjof8QiOuTHcECtkcQjuLBfpeOIsjhUZwkSHzuUOa8JweHaRHQfGyGW4IukYdatTDw/1CI6kbiyOCgLEnBTkGocSIOQRxIx0kD68Kh+vET3kDd0rdLBrCDHDgiOGvBAhM9IIg0OuZxIUcLwih8eDKso/6z6BFR1ETDg19a6nHSh9ZDA/kJA58CoEU4wlEzoOUjH78hRyGbBUQeCBKEyhyh2C/0ECqQbjk4iHsHkQcRDiK7D1XBFCMZHyPkfghHXZHBgjhbhgi3KcIKwkmOyPBqTokwZNyXUzaBFDujGhzDkY5ryHcw/FhAv8PCBCL444lvfr6hg2EPhAin0R2vELdwmR4uGyYeHqOF4OGCI+EHTkdF8ObynWR8//i+DiNiDy6BBfFJw5hwRdBBM7iEEOsGDCCBiiPSUNIeVPWLoIzX44got0RuDLghH+kohIV4YJaVqMFVA4RHXl/2UH1Cj3oIscjHMPnHSsoc75Ef4jBBBRr8cw6nHWiK5Dj39DN0QzCEwikxBFPEzWQIHBF0EvDXG7LHBAssQU+Q8BkcUjsIIOxtJIocMMscUsQ6wl+N6WRB/EVYPsERyI+ih14c8MJLM7sucPkFcfCQIF2F4dbE/nkDjw9yY9Ai6BAvlPwwaFhngER8j1JIQy8LkeEGdyLBWEHccb0R06WJ5CKXwih8cHB/0ioQXDXC4QRxyIOCEj4Iw4IIGby6Bk3bKwQRHwiEHEQoPVFWiPgzrfDrkY5Tt98RozxlJ1zjx4QTCKfbM6CjNBG6iZwUjgFBQY+Z4+IQK46BEcgoOc8jouuDMLCBQcEb8JeG39oui/hlDv80wfgjsJ4QTCOOTeX13yI8T0R8QkbwQL4wmR4HoRCBDCQ2Cr4SJjucd2QLLr7e7fEMFE6IWeYKjnoIMIFE8I5HqzCZ6YYRQ8RDZHPHEe3YIftAgVAgWcSB4IEPqX/hVUP3CPALhl0kZEfeUO9yOyOwpqWODggg2R1/rgj0Ouk2THCBOGGggUHDCDLovvDHBsRwYQUM8MwRHyP8Je9BggU56u5tBMuggWgiOnD4n8R8ocKIZdK7D/IhSr9uW/e5Pocj4hsRct1TjKspwQ44jJqhSxEtzRRES3Uso+W4PL5jMMzZgggiPl6/vwRdQSNHbtRlckRtHI2v1vq/+VxZF8uX+TpBModKPXrayv2XjCLjL5dfO///6g/g4IF73zv7/ftBEf74fBEf/4/+//3f+wbt4/BEf2Z/hAvv6+/q/BF15hd13/////+D+/XbC//6v/v9er9vYPOxMN/YeuGH6V89uT+9CPv1/jg/8R/x/70ZCA36dnkZE3GBuACACA</APP_SIGNATURE>
      </ROW>
      </DEMOGRAPHIC_DETAIL>
      Cheers,
      San.
        • 1. Re: XML data to Oracle Table
          AlexAnd
          forum has many examples
          plz search

          for example
          Re: Load an XML file into table(s)
          • 2. Re: XML data to Oracle Table
            San
            I have tried with some xml type prgram , but the column called signature its contain a big data its not loaded in clob also. Please help me out to resolve.
            • 3. Re: XML data to Oracle Table
              AlexAnd
              >
              I have tried with some xml type prgram , but the column called signature its contain a big data its not loaded in clob also.
              >
              can you post what are you trying to do?
              Connected to:
              Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
              With the Partitioning, OLAP, Data Mining and Real Application Testing options
              
              SQL> select x.APP_SIGNATURE
                2  from xmltable('/DEMOGRAPHIC_DETAIL/ROW'
                3                     passing xmltype(bfilename('MYDIR','signature.xml'),NLS_C
              HARSET_ID('AL32UTF8'))
                4                     columns APP_SIGNATURE clob path 'APP_SIGNATURE'
              
                5                            ) x;
              
              APP_SIGNATURE
              --------------------------------------------------------------------------------
              
              SUkqAAgAAAASAP4ABAABAAAAAAAAAAABAwABAAAAkwEAAAEBAwABAAAAkwEAAAIBAwABAAAAAQAAAAMB
              
              
              SQL> create table t_with_sign(col clob);
              
              Table created.
              
              SQL> insert into t_with_sign
                2  select x.APP_SIGNATURE
                3  from xmltable('/DEMOGRAPHIC_DETAIL/ROW'
                4                     passing xmltype(bfilename('MYDIR','signature.xml'),NLS_C
              HARSET_ID('AL32UTF8'))
                5                     columns APP_SIGNATURE clob path 'APP_SIGNATURE'
              
                6                            ) x;
              
              1 row created.
              
              SQL> select * from t_with_sign;
              
              COL
              --------------------------------------------------------------------------------
              
              SUkqAAgAAAASAP4ABAABAAAAAAAAAAABAwABAAAAkwEAAAEBAwABAAAAkwEAAAIBAwABAAAAAQAAAAMB
              
              
              SQL>
              • 4. Re: XML data to Oracle Table
                San
                Hi,

                Thanks for your reply.
                When i execute the below select statement i am getting the below mentioned error
                select x.APP_SIGNATURE
                from xmltable('/DEMOGRAPHIC_DETAIL/ROW'
                                   passing xmltype(bfilename('SMFAPEXDE','Sample7.xml'),NLS_CHARSET_ID('AL32UTF8'))
                                  columns APP_SIGNATURE clob path 'APP_SIGNATURE'
                  ) X;
                
                
                ORA-01706: user function result value was too large
                01706. 00000 -  "user function result value was too large"
                *Cause:    
                *Action:
                My Database version is
                Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
                PL/SQL Release 10.2.0.4.0 - Production
                "CORE     10.2.0.4.0     Production"
                TNS for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Productio
                NLSRTL Version 10.2.0.4.0 - Production
                Kindly help me to proceed further.

                Cheers,
                San.
                • 5. Re: XML data to Oracle Table
                  AlexAnd
                  try
                  Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 
                  Connected as scott
                   
                  SQL> create table t_with_sign2(col clob);
                   
                  Table created
                   
                  SQL>
                  SQL> insert into t_with_sign2
                    2  select x.APP_SIGNATURE.getclobval()
                    3  from xmltable('/DEMOGRAPHIC_DETAIL/ROW'
                    4                     passing xmltype(bfilename('MYDIR','signature.xml'),NLS_CHARSET_ID('AL32UTF8'))
                    5                    columns APP_SIGNATURE xmltype path 'APP_SIGNATURE/text()'
                    6    ) X;
                   
                  1 row inserted
                   
                  SQL> select * from t_with_sign2;
                   
                  COL
                  --------------------------------------------------------------------------------
                  SUkqAAgAAAASAP4ABAABAAAAAAAAAAABAwABAAAAkwEAAAEBAwABAAAAkwEAAAIBAwABAAAAAQAAAAMB
                   
                  SQL> 
                  • 6. Re: XML data to Oracle Table
                    San
                    Hi,

                    Thank you so much for your efforts. Its really working perfectly. But for some cases am getting the following error. How can i sort it out? Pl suggest and advice.
                    Error starting at line 4 in command:
                    insert into SBFS_KYC_DATA_TBL1(APP_SIGNATURE)
                      select x.APP_SIGNATURE.getclobval()
                      FROM XMLTABLE('/DEMOGRAPHIC_DETAIL/ROW'
                      passing xmltype(bfilename('SMFAPEXDE','Sample.xml'),NLS_CHARSET_ID('AL32UTF8'))
                      columns APP_SIGNATURE xmltype path 'APP_SIGNATURE/text()'
                      ) X
                    Error report:
                    SQL Error: ORA-31167: XML nodes over 64K in size cannot be inserted
                    ORA-06512: at "SYS.XMLTYPE", line 295
                    ORA-06512: at line 1
                    31167. 00000 -  "XML nodes over 64K in size cannot be inserted"
                    *Cause:    An attempt was made to insert an XML Text Node with a size
                               greater than 64K.  This is not supported.
                    *Action:   Create text nodes under 64K.
                    Cheers,
                    San.
                    • 7. Re: XML data to Oracle Table
                      AlexAnd
                      plz see
                      XMLTYPE Limited to 64k But DBMS_LOB.GETLENGTH() Returns Misleading Size in 9.2 When Clob > 64k [ID 421152.1]

                      also read
                      ORA-31167: 64k size limit for XML node
                      where
                      >
                      In 10.x if we detect a node > 64K while parsing the document we throw an error.
                      >
                      by mdrake