SHOW:
|
|
- or go back to the newest paste.
| 1 | - | create or replace |
| 1 | + | |
| 2 | - | procedure num_test_as_pls is |
| 2 | + | for i in power(2,31) .. power(2,31)+10 loop |
| 3 | - | x pls_integer; |
| 3 | + | null; |
| 4 | - | t number := dbms_utility.get_time; |
| 4 | + | end loop; |
| 5 | end; | |
| 6 | - | for i in 1..10000000 loop |
| 6 | + | ------------------------------------------------ |
| 7 | - | x:=i; |
| 7 | + | ERROR at line 1: |
| 8 | - | end loop; |
| 8 | + | ORA-01426: numeric overflow |
| 9 | - | dbms_output.put_line((dbms_utility.get_time-t)||'cs'); |
| 9 | + | ORA-06512: at line 2 |
