title: PL/SQL float addition
body: <p>I would like to add a value to a float but it's not working.</p>
  
  <p>I have a float, like 3.14 and I want to add 0.005 but I get 3.14.</p>
  
  <p>The code :</p>
  
  <pre><code>create or replace package pck_test is
  
  PROCEDURE ArrondiGeo(coord_x IN FLOAT,coord_y IN FLOAT,temp_x OUT FLOAT);
  
  end pck_test;
  /
  
  create or replace package body pck_test is
  
  
      PROCEDURE ArrondiGeo(coord_x IN FLOAT,coord_y IN FLOAT,temp_x OUT FLOAT,temp_y OUT FLOAT)
      IS
          tp_x FLOAT;
      BEGIN
          tp_x := mod(coord_x*10000,10);
  
          if(tp_x&gt;50)
          then
              if(tp_x&gt;75)
              then
                  temp_x:=trunc(coord_x,2);
                  temp_x:=temp_x+0.01;
              else
                  temp_x:=trunc(coord_x,2);
                  temp_x:=temp_x+0.005;
              end if;
          else
              if(tp_x&gt;25)
              then
                  temp_x:=trunc(coord_x,2);
                  temp_x:=temp_x+0.005;
              else
                  temp_x:=trunc(coord_x,2);
              end if;
          end if;
  
  
      END;
  END pck_test;
  /
  </code></pre>
  
  <p>Does anyone know why it's not working ?</p>