title: PL/SQL call to procedure
body: <p>I wrote a PL/SQL procedure to update the salary of the table Employee</p>
  
  <pre><code>create table Employee
  (ID                 VARCHAR2(4 BYTE)         NOT NULL,
  First_Name         VARCHAR2(10 BYTE),
     Last_Name          VARCHAR2(10 BYTE),
     Start_Date         DATE,
     End_Date           DATE,
      Salary             Number(8,2),
     City               VARCHAR2(10 BYTE),
      Description        VARCHAR2(15 BYTE)
  )
   /
  </code></pre>
  
  <p>And this is the procedure</p>
  
  <pre><code>CREATE OR REPLACE PROCEDURE update_employee_salary(
     p_factor IN NUMBER
      ) AS
      v_employee_count INTEGER;
      BEGIN
          UPDATE employee
         SET salary = salary * p_factor;
         COMMIT;
      EXCEPTION
       WHEN OTHERS THEN
         ROLLBACK;
     END update_employee_salary;
     /
  </code></pre>
  
  <p>When I try to call the procedure</p>
  
  <pre><code>CALL update_employee_salary (1.5)
  </code></pre>
  
  <p>oracle displays <code>ORA-00900: invalid SQL statement</code></p>