title: create withdrawal procedure in oracle pl/sql
body: <p>I want to create a withdrawal procedure in oracle pl/sql.</p>
  
  <p>I have this table </p>
  
  <pre><code>ACCOUNT_NO BRANCH_NAME                                        AMOUNT_BALANCE
  ---------- -------------------------------------------------- --------------
         102 MA                                                      32900
         101 NA                                                      32000
         103 IA                                                      50000
         104 SA                                                      45000
         105 MSA                                                     20000
  </code></pre>
  
  <p>I try to use this code  </p>
  
  <pre><code>CREATE OR REPLACE  PROCEDURE withdrawal_proc IS
  
  con  number(6);
  con1 number(6);
  bal1 number(20);
  bal2 number(20);
  
  begin
  
  con := &amp;con;
  bal1 := &amp;bal;
  
  select Account_No, Amount_Balance into con1, bal2 from Accounts where Account_No=con;
  
  if (bal2 &lt; bal1)
  
  dbms_output.put_line('the amount enterd is more than the amount balance');
  else
  
  update Accounts set Amount_Balance=(bal1-bal2) where con =con1;
  end if; 
  
  dbms_output.put_line('Money has been Withdraw succesfully');
  END;
  /
  </code></pre>
  
  
  
  <p>but there is a Warning: Procedure created with compilation errors.</p>