Write a PL/SQL program to show the upper limit of PLS_INTEGER

hamza

Save to bookmark

2022-05-18

189

Write a PL/SQL program to show the upper limit of PLS_INTEGER.

pl/sql,

hamza

2022-05-18

need an explanation for this answer? contact us directly to get an explanation for this answer

PL/SQL Code:

DECLARE
  n1 PLS_INTEGER := 2147483647;
  n2 PLS_INTEGER := 1;
  s NUMBER;
BEGIN
  s := n1 + n2;
END;
/

Sample Output:

DECLARE
*
ERROR at line 1:
ORA-01426: numeric overflow
ORA-06512: at line 6

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)