BINARY_INTEGER assignment : Binary Data Type « Data Type « Oracle PL / SQL






BINARY_INTEGER assignment

  
SQL>
SQL> DECLARE
  2    v_BinInt BINARY_INTEGER;
  3  BEGIN
  4    v_BinInt := 2147483647;
  5    v_BinInt := v_BinInt + 1 - 1;
  6  END;
  7  /
DECLARE
*
ERROR at line 1:
ORA-01426: numeric overflow
ORA-06512: at line 5


SQL>

   
  








Related examples in the same category

1.Use binary data type
2.BINARY_INTEGER as loop counter
3.BINARY_FLOAT and BINARY_DOUBLE example
4.BINARY_FLOAT_INFINITY, BINARY_DOUBLE_INFINITY