ORA-01426: numeric overflow : ORA Error « System Packages « Oracle PL / SQL






ORA-01426: numeric overflow

  
SQL>
SQL> begin
  2       for i in power(2,31) .. power(2,31)+10 loop
  3           null;
  4       end loop;
  5   end;
  6  /
begin
*
ERROR at line 1:
ORA-01426: numeric overflow
ORA-06512: at line 2


SQL>
SQL>

   
    
  








Related examples in the same category

1.ORA-00918: column ambiguously defined
2.ORA-00934: group function is not allowed here
3.ORA-00979: not a GROUP BY expression
4.ORA-01403: no data found
5.ORA-01403: no data found exception from procedure
6.ORA-01422: exact fetch returns more than requested number of rows
7.ORA-01839: date not valid for month specified
8.ORA-06502: PL/SQL: numeric or value error
9.ORA-06502: PL/SQL: numeric or value error: character to number conversion error
10.ORA-06502: PL/SQL: numeric or value error: number precision too large
11.ORA-06503: PL/SQL: Function returned without value
12.ORA-14551: cannot perform a DML operation inside a query