ORA-06502: PL/SQL: numeric or value error ORA-06512: at "SYS.DBMS_LOB", line 1163 ORA-06512: at line 31v
when executing attached code in Toad 16.2. If you comment any line of code with DBMS_OUTPUT it works fine. Besides Line number: 31 provided in error doesn't match with the code as it has only 29 lines.