title: PLSQL Invalid Month
body: <p>Why am I getting invalid month when I test this code? How does PLSQL and XML handle data types?  </p>
  
  <pre><code>CURSOR c_DATA_INF is 
    select * from xmltable ('/' PASSING i_XML COLUMNS READING_DT DATE PATH 'DATE',
                            Actual NUMBER PATH 'ACTUAL',
                            Eligible NUMBER PATH 'ELIGIBLE'
                           );
                begin
                  for d in c_DATA_INF loop                  
                    insert into table_name(READING_DT, actual, eligible) 
                    values (to_date('d.READING_DT', 'MM/DD/YYYY'), d.ACTUAL, d.ELIGIBLE);
                  end loop;
                end;
  </code></pre>
  
  <p>I'm not sure if it's incorrect in my insert statement or in my cursor.<br>
  Thanks!</p>