title: PLS-00103: Encountered the symbol “;” when expecting one of the following:
body: <p>What is wrong with my PLSQL?</p>
  
  <p>I get this error message:</p>
  
  <pre><code>ORA-06550: line 4, column 0:PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:* &amp; = - + ; &lt; / &gt; at in is mod remainder not rem &lt;an exponent (**)&gt; &lt;&gt; or != or ~= &gt;= &lt;= &lt;&gt; and or like like2 like4 likec between || multiset member submultiset
  </code></pre>
  
  <p>|</p>
  
  <pre><code>&lt;&lt;outer_block&gt;&gt;
  DECLARE
  mgr_id NUMBER(6) :='&amp;current_manager_id';
  dept_count number := 0;
  BEGIN
  SELECT count(*) INTO dept_count FROM EMP WHERE EMPNO = outer_block.mgr_id;
  IF dept_count &gt; 0 THEN
      &lt;&lt; inner_block &gt;&gt;
      DECLARE
          dept_name VARCHAR2(30);
          mgr_id NUMBER(6) := &amp;new_manager_id;
      BEGIN
          SELECT EMPNO INTO dept_name FROM EMP WHERE manager_id = outer_block.mgr_id; 
          UPDATE EMP SET MGR = inner_block.mgr_id WHERE MGR = outer_block.mgr_id;
          DBMS_OUTPUT.PUT_LINE('Department manager ID has been changed for ' || dept_name);
      END inner_block;
  ELSE
      DBMS_OUTPUT.PUT_LINE('There are no departments listed for the manager');
  END IF;
  EXCEPTION
      WHEN NO_DATA_FOUND THEN
          DBMS_OUTPUT.PUT_LINE('There are no departments listed for the manager');
  END outer_block;
  /
  </code></pre>