title: Oracle Warning: execution completed with warning
body: <p>I have two tables</p>
  
  <pre><code>Orders(ID,ORDERDATE,DELIVERYDATE,GOODID,QUANTITY,COLLECTIONFROM,DELIVERYTO,NOTES)
  </code></pre>
  
  <p>and </p>
  
  <pre><code>ROLLINGSTOCK_ORDER(ORDERID,ROLLINGSTOCKID,DEPARTUREDATE,DELIVERYDATE,ROUTEID)
  </code></pre>
  
  <p>i have created a trigger to update the DELIVERYDATE in <code>ROLLINGSTOCK_ORDER</code> when DELIVERYDATE is updated in <code>Orders</code> </p>
  
  <pre><code>CREATE OR REPLACE TRIGGER TRIGGER_UpdateDeliveryDate
  BEFORE UPDATE OF DELIVERYDATE ON Orders 
  FOR EACH ROW 
  BEGIN    
  then
     UPDATE LOCOMOTIVE_DRIVER ld
     set ld.DELIVERYDATE = :new.DELIVERYDATE
     where ld.orderid = :new.id
  end if;
  END;
  </code></pre>
  
  <p>When i run it i get the following message</p>
  
  <blockquote>
    <p>Warning: execution completed with
    warning TRIGGER
    TRIGGER_UpdateDeliveryDate Compiled.</p>
  </blockquote>
  
  <p>The warning does not give me any information so </p>
  
  <ol>
  <li><p>How can i see the details of the warning?</p></li>
  <li><p>The trigger seems ok to me can you spot the problem?</p></li>
  </ol>
  
  <p>Thanks</p>