clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 1130665 fiddles created (16586 in the last week).

create or replace package lib_errortest as procedure proc1; end lib_errortest; /
 hidden batch(es)


create or replace package body lib_errortest as procedure proc2 as v_number integer; begin v_number := 1 / 0; end; procedure proc1 as begin proc2; exception when others then dbms_output.put_line('SQLERRM'); dbms_output.put_line(sqlerrm); dbms_output.put_line('---------------------------------------'); dbms_output.put_line('FORMAT_ERROR_BACKTRACE'); dbms_output.put_line(dbms_utility.format_error_backtrace); dbms_output.put_line('---------------------------------------'); dbms_output.put_line('FORMAT_ERROR_STACK'); dbms_output.put_line(dbms_utility.format_error_stack); end; end lib_errortest; /
 hidden batch(es)


begin lib_errortest.proc1; end; /
1 rows affected dbms_output: SQLERRM ORA-01476: divisor is equal to zero --------------------------------------- FORMAT_ERROR_BACKTRACE ORA-06512: at "FIDDLE_ZRDXCKAWKPQVAUQLTLMX.LIB_ERRORTEST", line 5 ORA-06512: at "FIDDLE_ZRDXCKAWKPQVAUQLTLMX.LIB_ERRORTEST", line 10 --------------------------------------- FORMAT_ERROR_STACK ORA-01476: divisor is equal to zero ORA-06512: at "FIDDLE_ZRDXCKAWKPQVAUQLTLMX.LIB_ERRORTEST", line 5
 hidden batch(es)