title: TRIGGER tU_DEDPARM_OEFix compiled Warning: execution completed with warning
body: <p>I am running below create trigger query in Oracle :-</p>
  
  <pre><code>SQL&gt;CREATE OR REPLACE TRIGGER tU_DEDPARM_OEFix 
    AFTER INSERT OR UPDATE ON DED_PARM FOR EACH ROW 
  BEGIN    
    UPDATE DED_PARM SET  
       DED_PARM.OVRD_DED_AM = COALESCE(i.OVRD_DED_AM,0.00), 
       DED_PARM.OVRD_DED_PC = COALESCE(i.OVRD_DED_PC,0.00000)    
         FROM   DED_PARM AS d INNER JOIN inserted AS i  
           ON (i.INTERNAL_EMPL_ID=d.INTERNAL_EMPL_ID AND 
              i.APPOINTMENT_ID=d.APPOINTMENT_ID AND 
              i.DEDTYP_CD=d.DEDTYP_CD AND  
              i.EFFECTIVE_DT=d.EFFECTIVE_DT) 
    END; /
  </code></pre>
  
  <p>After execution of the query i faced below error :-</p>
  
  <blockquote>
    <p>TRIGGER tU_DEDPARM_OEFix compiled Warning: execution completed with
    warning.</p>
  </blockquote>
  
  <p>Then i ran the below query to see the compilation errors </p>
  
  <blockquote>
    <p>SQL>show error Errors for TRIGGER TU_DEDPARM_OEFIX;</p>
  </blockquote>
  
  <p>Below are the errors :-</p>
  
  <blockquote>
    <p>5/3            PL/SQL: ORA-00933: SQL command not properly ended 2/3<br>
    PL/SQL: SQL Statement ignored 10/4           PLS-00103: Encountered
    the symbol "end-of-file" when expecting one of the following:</p>
    
    <p>( begin case declare end exception exit for goto if loop mod<br>
    null pragma raise return select update while with    
         &lt;&lt;
    continue close current delete fetch lock    insert open rollback
    savepoint set sql execute commit forall    merge pipe purge</p>
  </blockquote>
  
  <p>Can somebody help me to prepare correct query. FYI- The trigger is created but it is created with compilation errors that i showed above.</p>
  
  <p>Thanks!!</p>