title: Error: PL/SQL: SQL Statement ignored
body: <p>I'm trying to Add a column to a new table and update that column using procedure. But I'm getting 2 errors.</p>
  
  <blockquote>
    <p>Error: PL/SQL: SQL Statement ignored. Error: PL/SQL: ORA-00947: not
    enough values</p>
  </blockquote>
  
  <p>Don't Know how to figure out them. Please help me!!</p>
  
  <pre><code>ALTER TABLE emp1
    ADD Bonus integer;
  
  set serveroutput on
  
  CREATE OR REPLACE Procedure proc2_update
  
  AS
  
  BEGIN
  
     dbms_output.put_line('Truncate Table emp1');
  
     execute immediate 'truncate table emp1';
  
     dbms_output.put_line('Truncated Table emp1 successfully');
  
     dbms_output.put_line('Insert into Table emp1');
  
     insert into emp1 select * from emp;
  
     dbms_output.put_line('Inserted into Table emp1 successfully');
  
     dbms_output.put_line('Update Table emp1');
  
     if Deptno= 10 then 
  
    update emp1 set Bonus = sal * 10/100;
  
    Elsif Deptno= 20 then 
  
    update emp1 set Bonus = sal * 20/100;
  
    elsif Deptno= 30 then 
  
    update emp1 set Bonus = sal * 30/100;
  
    else 
  
    update emp1 set Bonus = sal * 40/100;
  
    end if;
  
     END proc2_update;
  </code></pre>
  
  <p>/</p>