Thanks for the question, Nidhika.
Asked: January 22, 2020 - 3:45 pm UTC
Last updated: January 09, 2024 - 2:24 pm UTC
Version: Oracle 12
Viewed 1000+ times
CREATE OR REPLACE PROCEDURE bad_proc IS x INT; BEGIN SELECT 1 INTO x FROM dual; dbms_output.put_line(x); SELECT 2 INTO x FROM dual; dbms_output.put_line(x); SELECT 4/0 INTO x FROM dual; dbms_output.put_line(x); SELECT 5 INTO x FROM dual; dbms_output.put_line(x); SELECT 6 INTO x FROM dual; dbms_output.put_line(x); EXCEPTION WHEN zero_divide THEN dbms_output.put_line('HELP - I DIED HERE=>'||dbms_utility.format_error_backtrace ); END; / set serveroutput on; exec BAD_PROC;
PL/SQL procedure successfully completed. 1 2 HELP - I DIED HERE=>ORA-06512: at "HR.BAD_PROC", line 9
PL/SQL procedure successfully completed. 1 2 HELP - I DIED HERE=>ORA-06512: at "HR.BAD_PROC", line 9 5 6
CREATE OR REPLACE PROCEDURE bad_proc IS x INT; BEGIN begin SELECT 1 INTO x FROM dual; dbms_output.put_line(x); EXCEPTION WHEN zero_divide THEN dbms_output.put_line('HELP - I DIED HERE=>'||dbms_utility.format_error_backtrace ); end; begin SELECT 2 INTO x FROM dual; dbms_output.put_line(x); EXCEPTION WHEN zero_divide THEN dbms_output.put_line('HELP - I DIED HERE=>'||dbms_utility.format_error_backtrace ); end; begin SELECT 4/0 INTO x FROM dual; dbms_output.put_line(x); EXCEPTION WHEN zero_divide THEN dbms_output.put_line('HELP - I DIED HERE=>'||dbms_utility.format_error_backtrace ); end; begin SELECT 5 INTO x FROM dual; dbms_output.put_line(x); EXCEPTION WHEN zero_divide THEN dbms_output.put_line('HELP - I DIED HERE=>'||dbms_utility.format_error_backtrace ); end; begin SELECT 6 INTO x FROM dual; dbms_output.put_line(x); EXCEPTION WHEN zero_divide THEN dbms_output.put_line('HELP - I DIED HERE=>'||dbms_utility.format_error_backtrace ); end; END; / set serveroutput on; exec BAD_PROC; 1 2 HELP - I DIED HERE=>ORA-06512: at "CHRIS.BAD_PROC", line 20 5 6 PL/SQL procedure successfully completed.
Rami Reddy V, December 20, 2023 - 2:40 pm UTC
Check out more PL/SQL tutorials on our LiveSQL tool.
PL/SQL reference manual from the Oracle documentation library