title: Oracle APEX PL/SQL Procedure Debugging?
body: <p>I am using a PL/SQL Procedure to Insert one Table that was previously generated into another exisiting table:</p>
  
  <pre><code>INSERT INTO REI_LABOUR_COST (DEALER_NUMBER, DEALER_STATUS, BILLING_PARTNER, BSI_GW, YEAR, QUANTITY_FRU, LABOUR_EUR, LABOUR_LOCAL, REQUESTED_RATE)
  select c001 as DEALER_NUMBER
       , c002 as DEALER_STATUS
       , c003 as BILLING_PARTNER
       , c004 as BSI_GW
       , c005 as YEAR
       , c006 as QUANTITY_FRU
       , c007 as LABOUR_EUR
       , c008 as LABOUR_LOCAL
       , c009 as REQUESTED_RATE
  from apex_collections col
  where collection_name = 'COLLECTION' and seq_id != 1
  order by seq_id;
  </code></pre>
  
  <p>But it does not work. There is no error message or other sign of the procedure failing, but it does not show any results in the final table.</p>
  
  <p>First question, is there any sign what I did wrong?</p>
  
  <p>Second question, where would I see an error message if the command fails? Can I enable it somewhere?</p>