declare
l_number pls_integer;
l_number1 number;
l_number2 float;
begin
begin
select power(2,1000) into l_number from dual;
exception when others then
dbms_output.put_line('pls_integer->'||sqlerrm);
end;
begin
select power(2,1000) into l_number1 from dual;
exception when others then
dbms_output.put_line('number->'||sqlerrm);
end;
begin
select power(2,1000) into l_number2 from dual;
exception when others then
dbms_output.put_line('float->'||sqlerrm);
end;
end;
pls_integer->ORA-01426: numeric overflow
number->ORA-01426: numeric overflow
float->ORA-01426: numeric overflow