title: Data not inserting into table via XML in Oracle
body: <p>I am trying to insert few records into one of my Oracle table. So for that I am using XML. Below is the XML which is inserted into the table.</p>
  <p>But without any error, it's not inserting the records.</p>
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>PROCEDURE UploadGTLData
  (
    BulkXML CLOB            
   )
   AS
   XMLType SYS.XMLTYPE;
      BEGIN
      XMLType:= SYS.XMLType.CreateXML(BulkXML);
      DECLARE
      
              ID   NVARCHAR2(100);
              SAP_ID   NVARCHAR2(100);
              CITY      NVARCHAR2(100 CHAR);
              CIRCLE      NVARCHAR2(100 CHAR);
              FINAL_SO_DATE     NVARCHAR2(100 CHAR);
              INVOICE_DATE      NVARCHAR2(100 CHAR);
              IP_ID            NVARCHAR2(100 CHAR);
              APPLICABLE_MSA    NVARCHAR2(100 CHAR);
              SITE_CATEGORY     NVARCHAR2(100 CHAR);
              ID_OD             NVARCHAR2(100 CHAR);
              RFI_DATE         NVARCHAR2(100 CHAR);
              BILL_START_DATE   NVARCHAR2(100 CHAR);
              BILL_END_DATE     NVARCHAR2(100 CHAR);
              NO_OF_OPCO        NVARCHAR2(100 CHAR);
              ACTUAL_RENT_AMT   NVARCHAR2(100 CHAR);
              TENURE            NVARCHAR2(100 CHAR);
              MW_ANTENNA_OF_UPTO06_DIA   NVARCHAR2(100 CHAR);
              MW_ANTENNA_OF_12DIA       NVARCHAR2(100 CHAR);
              MW_ANTENNA_OF_GREATER12_DIA    NVARCHAR2(100 CHAR);
              HEIGHT_OF_HEIGHEST_ANTENNA    NVARCHAR2(100 CHAR);
              SITE_RRH_COUNT                  NVARCHAR2(100 CHAR);
              WIND_SPEED                       NVARCHAR2(100 CHAR);
              GREATER_9_RRH                   NVARCHAR2(100 CHAR);
              FLOOR_SPACE_INDOOR              NVARCHAR2(100 CHAR); 
              FLOOR_SPACE_OUTDOOR             NVARCHAR2(100 CHAR);
              EB_STATUS_VALUE                 NVARCHAR2(100 CHAR);
              NO_OF_US                       NVARCHAR2(100 CHAR);
              VOLUME_DISCOUNT                  NVARCHAR2(100 CHAR);           
              
              BEGIN            
              FOR RECD IN           
              (            
              SELECT            
              Records.EXTRACT('//RecodSet/ID/text()').getstringval() As ID,
              Records.EXTRACT('//RecodSet/SAP_ID/text()').getstringval() As SAP_ID,            
              Records.EXTRACT('//RecodSet/CITY/text()').getstringval() As CITY,            
              Records.EXTRACT('//RecodSet/CIRCLE/text()').getstringval() As CIRCLE,
              Records.EXTRACT('//RecodSet/FINAL_SO_DATE/text()').getstringval() As FINAL_SO_DATE,            
              Records.EXTRACT('//RecodSet/INVOICE_DATE/text()').getstringval() As INVOICE_DATE , 
              Records.EXTRACT('//RecodSet/IP_ID/text()').getstringval() As IP_ID  ,          
              Records.EXTRACT('//RecodSet/APPLICABLE_MSA/text()').getstringval() As APPLICABLE_MSA,
              Records.EXTRACT('//RecodSet/SITE_CATEGORY/text()').getstringval() As SITE_CATEGORY,
              Records.EXTRACT('//RecodSet/ID_OD/text()').getstringval() As ID_OD ,           
              Records.EXTRACT('//RecodSet/RFI_DATE/text()').getstringval() As RFI_DATE ,
              Records.EXTRACT('//RecodSet/BILL_START_DATE/text()').getstringval() As BILL_START_DATE,
              Records.EXTRACT('//RecodSet/BILL_END_DATE/text()').getstringval() As BILL_END_DATE ,
              Records.EXTRACT('//RecodSet/NO_OF_OPCO/text()').getstringval() As NO_OF_OPCO  ,
              Records.EXTRACT('//RecodSet/ACTUAL_RENT_AMT/text()').getstringval() As ACTUAL_RENT_AMT,
              Records.EXTRACT('//RecodSet/TENURE/text()').getstringval() As TENURE ,
              Records.EXTRACT('//RecodSet/MW_ANTENNA_OF_UPTO06_DIA /text()').getstringval() As MW_ANTENNA_OF_UPTO06_DIA ,
              Records.EXTRACT('//RecodSet/MW_ANTENNA_OF_12DIA/text()').getstringval() As MW_ANTENNA_OF_12DIA,
              Records.EXTRACT('//RecodSet/MW_ANTENNA_OF_GREATER12_DIA/text()').getstringval() As MW_ANTENNA_OF_GREATER12_DIA ,
              Records.EXTRACT('//RecodSet/HEIGHT_OF_HEIGHEST_ANTENNA/text()').getstringval() As HEIGHT_OF_HEIGHEST_ANTENNA ,
              Records.EXTRACT('//RecodSet/SITE_RRH_COUNT/text()').getstringval() As SITE_RRH_COUNT ,            
              Records.EXTRACT('//RecodSet/WIND_SPEED/text()').getstringval() As WIND_SPEED ,
              Records.EXTRACT('//RecodSet/GREATER_9_RRH/text()').getstringval() As GREATER_9_RRH ,
              Records.EXTRACT('//RecodSet/FLOOR_SPACE_INDOOR/text()').getstringval() As FLOOR_SPACE_INDOOR ,
              Records.EXTRACT('//RecodSet/FLOOR_SPACE_OUTDOOR/text()').getstringval() As FLOOR_SPACE_OUTDOOR ,            
              Records.EXTRACT('//RecodSet/EB_STATUS_VALUE/text()').getstringval() As EB_STATUS_VALUE ,
              Records.EXTRACT('//RecodSet/NO_OF_US/text()').getstringval() As NO_OF_US ,
              Records.EXTRACT('//RecodSet/VOLUME_DISCOUNT/text()').getstringval() As VOLUME_DISCOUNT            
              
              
              FROM TABLE(XMLSequence(XMLType.EXTRACT('//NewDataSet/RecodSet')))Records
              )LOOP
              DBMS_OUTPUT.PUT_LINE('INLOOP');            
              INSERT INTO IPCOLO_IPFEE_CALC_GTL(ID,SAP_ID,CITY,CIRCLE,FINAL_SO_DATE,INVOICE_DATE,IP_ID, APPLICABLE_MSA,SITE_CATEGORY,ID_OD,RFI_DATE,BILL_START_DATE,BILL_END_DATE ,NO_OF_OPCO,ACTUAL_RENT_AMT ,TENURE, MW_ANTENNA_OF_UPTO06_DIA, MW_ANTENNA_OF_12DIA, MW_ANTENNA_OF_GREATER12_DIA, HEIGHT_OF_HEIGHEST_ANTENNA, SITE_RRH_COUNT, WIND_SPEED, GREATER_9_RRH, FLOOR_SPACE_INDOOR, FLOOR_SPACE_OUTDOOR, EB_STATUS_VALUE, NO_OF_US, VOLUME_DISCOUNT)                                    
              VALUES (RECD.ID,RECD.SAP_ID,RECD.CITY,RECD.CIRCLE,RECD.FINAL_SO_DATE,RECD.INVOICE_DATE,RECD.IP_ID, RECD.APPLICABLE_MSA, RECD.SITE_CATEGORY,RECD.ID_OD, RECD.RFI_DATE,RECD.BILL_START_DATE,RECD.BILL_END_DATE , RECD.NO_OF_OPCO, RECD.ACTUAL_RENT_AMT ,RECD.TENURE, RECD.MW_ANTENNA_OF_UPTO06_DIA, RECD.MW_ANTENNA_OF_12DIA, RECD.MW_ANTENNA_OF_GREATER12_DIA, RECD.HEIGHT_OF_HEIGHEST_ANTENNA, RECD.SITE_RRH_COUNT, RECD.WIND_SPEED, RECD.GREATER_9_RRH, RECD.FLOOR_SPACE_INDOOR, RECD.FLOOR_SPACE_OUTDOOR, RECD.EB_STATUS_VALUE, RECD.NO_OF_US, RECD.VOLUME_DISCOUNT);
              
              END LOOP;
              DBMS_OUTPUT.PUT_LINE('OUTLOOP');
              END;
  
  
  END UploadGTLData;</code></pre>
  </div>
  </div>
  </p>
  <p>Also below is the table desc</p>
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>Name                        Null Type           
  --------------------------- ---- -------------- 
  ID                               NVARCHAR2(100) 
  SAP_ID                           NVARCHAR2(100) 
  CITY                             NVARCHAR2(100) 
  CIRCLE                           NVARCHAR2(100) 
  FINAL_SO_DATE                    NVARCHAR2(100) 
  INVOICE_DATE                     NVARCHAR2(100) 
  IP_ID                            NVARCHAR2(100) 
  APPLICABLE_MSA                   NVARCHAR2(100) 
  SITE_CATEGORY                    NVARCHAR2(100) 
  ID_OD                            NVARCHAR2(100) 
  RFI_DATE                         NVARCHAR2(100) 
  BILL_START_DATE                  NVARCHAR2(100) 
  BILL_END_DATE                    NVARCHAR2(100) 
  NO_OF_OPCO                       NVARCHAR2(100) 
  ACTUAL_RENT_AMT                  NVARCHAR2(100) 
  TENURE                           NVARCHAR2(100) 
  MW_ANTENNA_OF_UPTO06_DIA         NVARCHAR2(100) 
  MW_ANTENNA_OF_12DIA              NVARCHAR2(100) 
  MW_ANTENNA_OF_GREATER12_DIA      NVARCHAR2(100) 
  HEIGHT_OF_HEIGHEST_ANTENNA       NVARCHAR2(100) 
  SITE_RRH_COUNT                   NVARCHAR2(100) 
  WIND_SPEED                       NVARCHAR2(100) 
  GREATER_9_RRH                    NVARCHAR2(100) 
  FLOOR_SPACE_INDOOR               NVARCHAR2(100) 
  FLOOR_SPACE_OUTDOOR              NVARCHAR2(100) 
  EB_STATUS_VALUE                  NVARCHAR2(100) 
  NO_OF_US                         NVARCHAR2(100) 
  VOLUME_DISCOUNT                  NVARCHAR2(100) </code></pre>
  </div>
  </div>
  </p>
  <p>The generated XML is below</p>
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>&lt;DocumentElement&gt;
    &lt;RecodSet&gt;
      &lt;ID&gt;1&lt;/ID&gt;
      &lt;SAP_ID&gt;I-HR-BWKR-ENB-G001&lt;/SAP_ID&gt;
      &lt;CITY&gt;OTHERS&lt;/CITY&gt;
      &lt;CIRCLE&gt;Haryana&lt;/CIRCLE&gt;
      &lt;FINAL_SO_DATE&gt;05-08-2016&lt;/FINAL_SO_DATE&gt;
      &lt;INVOICE_DATE&gt;05-07-2021&lt;/INVOICE_DATE&gt;
      &lt;IP_ID&gt;HAR/GBT/A/05661&lt;/IP_ID&gt;
      &lt;APPLICABLE_MSA&gt;MSA_1&lt;/APPLICABLE_MSA&gt;
      &lt;SITE_CATEGORY&gt;GBT&lt;/SITE_CATEGORY&gt;
      &lt;ID_OD&gt;OD&lt;/ID_OD&gt;
      &lt;RFI_DATE&gt;27-10-2016&lt;/RFI_DATE&gt;
      &lt;BILL_START_DATE&gt;01-07-2021&lt;/BILL_START_DATE&gt;
      &lt;BILL_END_DATE&gt;31-07-2021&lt;/BILL_END_DATE&gt;
      &lt;NO_OF_OPCO&gt;2&lt;/NO_OF_OPCO&gt;
      &lt;ACTUAL_RENT_AMT&gt;0&lt;/ACTUAL_RENT_AMT&gt;
      &lt;TENURE&gt;10&lt;/TENURE&gt;
      &lt;MW_ANTENNA_OF_UPTO06_DIA&gt;0&lt;/MW_ANTENNA_OF_UPTO06_DIA&gt;
      &lt;MW_ANTENNA_OF_12DIA&gt;0&lt;/MW_ANTENNA_OF_12DIA&gt;
      &lt;MW_ANTENNA_OF_GREATER12_DIA&gt;0&lt;/MW_ANTENNA_OF_GREATER12_DIA&gt;
      &lt;HEIGHT_OF_HEIGHEST_ANTENNA&gt;0.00&lt;/HEIGHT_OF_HEIGHEST_ANTENNA&gt;
      &lt;SITE_RRH_COUNT&gt;9&lt;/SITE_RRH_COUNT&gt;
      &lt;WIND_SPEED&gt;0&lt;/WIND_SPEED&gt;
      &lt;GREATER_9_RRH&gt;0&lt;/GREATER_9_RRH&gt;
      &lt;FLOOR_SPACE_INDOOR&gt;0&lt;/FLOOR_SPACE_INDOOR&gt;
      &lt;FLOOR_SPACE_OUTDOOR&gt;0&lt;/FLOOR_SPACE_OUTDOOR&gt;
      &lt;EB_STATUS_VALUE&gt;Y&lt;/EB_STATUS_VALUE&gt;
      &lt;NO_OF_US&gt;0&lt;/NO_OF_US&gt;
      &lt;VOLUME_DISCOUNT&gt;N&lt;/VOLUME_DISCOUNT&gt;
    &lt;/RecodSet&gt;
  &lt;/DocumentElement&gt;</code></pre>
  </div>
  </div>
  </p>
  <p>Where am I going wrong?</p>