PLS_INTEGER variable : PLS_INTEGER « Data Type « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Data Type
  3. PLS_INTEGER

PLS_INTEGER variable

   

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


SQL>








Related examples in the same category

1.Check value of PLS_INTEGER type variable
2.Assign loop counter to pls_integer type variable
3.Calculation with pls_integer
4.Count with pls_integer type variable
5.PLS_Integer type variable
6.The index variable is a PLS_INTEGER datatype number.
7.Calculate a grand total