title: java.sql.SQLException: ORA-24335: cannot support more than 1000 columns
body: <p>I have a java program which inserts a list of store numbers with a unique ID called <code>pilotID</code> into an Oracle database with the following syntax:</p>
  
  <pre><code>pilotDAO.insertPilotStores(pilotID, storeList);
  </code></pre>
  
  <p><code>storeList</code> is a <code>List&lt;String&gt;</code> storing store numbers, and <code>pilotID</code> is some integer like 101.</p>
  
  <p>However, when the <code>storelist</code> is more than 999 stores, I am getting a DB exception in Oracle: </p>
  
  <pre><code>Caused by:
      java.sql.SQLException: ORA-24335: cannot support more than 1000 columns
  </code></pre>
  
  <p>The insert query which in use is </p>
  
  <pre><code>INSERT ALL
    INTO eportal.pilot_store (pilot_id, store_nbr, last_updt_dt_tme) VALUES (96, 100, SYSDATE)
    INTO eportal.pilot_store (pilot_id, store_nbr, last_updt_dt_tme) VALUES (96, 101, SYSDATE)
    INTO eportal.pilot_store (pilot_id, store_nbr, last_updt_dt_tme) VALUES (96, 102, SYSDATE)
  SELECT * FROM dual;
  </code></pre>
  
  <p>I am really stuck here. Any suggestions are welcome.</p>
  
  <p>Thanks in advance<br>
  pooja</p>