title: Update multiple values in an oracle table using values from an APEX collection
body: <p>I am using APEX collections to store some values and pass them between pages in Oracle Application Express 4.2.3.</p>
  
  <p>I would like to then perform an update statement on a table called "project" with the values from the collection.</p>
  
  <p>My code so far is as follows:</p>
  
  <pre><code> update project
    SET name=c.c002, 
        description=c.c007, 
        start_date=c.c004, 
        timeframe=c.c005, 
        status=c.c009
    FROM 
        apex_collections c
    WHERE 
        c.collection_name = 'PROJECT_DETAILS_COLLECTION'
        and id = :p14_id;
  </code></pre>
  
  <p>where :p14_id is the value of a page item.</p>
  
  <p>However, I am getting the following error:</p>
  
  <pre><code>ORA-00933: SQL command not properly ended
  </code></pre>
  
  <p>Anyone have any idea on how to approach this?</p>
  
  <p>Thanks!</p>