title: Character to number conversion error
body: <pre><code>declare
     l_tot number := 0;
  
  begin
     for i in 1..apex_application.g_f08.count loop
        l_tot := l_tot + nvl(to_number(apex_application.g_f08(i)),0);
     end loop;
  
   if l_tot = nvl(to_number(:P21_TOTAL_PRICE),0) then
        return true;
     else
        return false;
     end if;
  end;
  </code></pre>
  
  <p>Got below error with above code</p>
  
  <pre><code>ORA-06502: PL/SQL: numeric or value error: character to number conversion error
  </code></pre>
  
  <p>Error occurred with <code>:P21_TOTAL_PRICE</code>. What is the wrong ? How can i correct this ?</p>