title: pls-00103 encountered the symbol '=' when expecting one of the following
body: <p>I get the error message pls-00103 at line 3 and 5 with this part of a trigger Im trying to make. If RENDEZVOUSSTART is after or equal to 6pm (18:00 here) the price multiplicator is 1.5 and the NOTAUXHORAIRE should be 1, in all other cases, the price multiplicator is 1 and NOTAUXHORAIRE is 0. </p>
  
  <p><div class="snippet" data-lang="js" data-hide="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>if to_char (:new.RENDEZVOUSSTART, 'HH24') &gt;= 18 
            THEN multiplicator := 1.5 
             and :new.NOTAUXHORAIRE := 1 ;
           else multiplicator := 1 
             AND :new.NOTAUXHORAIRE := 0;
          end if;</code></pre>
  </div>
  </div>
  </p>
  
  <p>Error(3,35): PLS-00103: Symbole "=" rencontré à la place d'un des symboles suivants :     . ( * @ % &amp; = - + ; &lt; / > at in is mod remainder not rem     &lt;> or != or ~= >= &lt;= &lt;> and or like like2    like4 likec between || indicator multiset member submultiset Symbole "* inséré avant "=" pour continuer. </p>
  
  <p>Thank you very much everyone! I just started to learn Sql for a business class and Im still a newbie :D </p>