title: Mule: referencing values from sub array to insert into database
body: <p>My incoming Payload is something like this, this is an ArrayList</p>
  
  <pre><code>  payload :[[a3An00000009Ej6EAE, a3An00000009EjGEAU, a3An00000009EjBEAU], [45000.0, 50000.0, 12000.0]]
  </code></pre>
  
  <p>I have more than one array in my incoming data.</p>
  
  <p>I can reference the id value as #[message.payload.id]&amp; put it in the insert statement:</p>
  
  <pre><code> &lt;db:parameterized-query&gt;&lt;![CDATA[INSERT INTO HDR_TABLE (ID) VALUES (#[message.payload.id])]]&lt;/db:parameterized-query&gt;
  </code></pre>
  
  <p>how can I reference two separate arrays in the code?</p>
  
  <pre><code>  &lt;db:bulk-execute config-ref="Oracle_Configuration" doc:name="Database"&gt;&lt;![CDATA[
  </code></pre>
  
  <p>INSERT INTO xxtw.XXTW_OE_CONTRACT_LINE(CONTRACT_LINE_ID,ATTRIBUTE1)VALUES(xxtw.XXTW_OE_CONTRACT_LINE_SEQ.NEXTVAL,'#[payload[0][0]]', '#[payload[0][1]]')</p>
  
  <pre><code>                                                                                                           ]]&gt;&lt;/db:bulk-execute&gt;                                                                                                  
       &lt;!--  &lt;foreach doc:name="For Each" collection="#[flowVars.extendedPrice]"&gt;
  </code></pre>