begin
/*
Unhandled re-raised exception.
Up to Oracle 11g, the output would not mention line 6.
*/
raise NO_DATA_FOUND;
exception
when others then
raise;
end; ORA-01403: no data found ORA-06512: at line 9 ORA-06512: at line 6 ORA-06512: at "SYS.DBMS_SQL", line 1721More Details: https://docs.oracle.com/error-help/db/ora-00100
begin
/*
Handled re-raised exception, display with FORMAT_ERROR_BACKTRACE.
Up to Oracle 11g, the output would not mention line 7.
*/
begin
raise NO_DATA_FOUND;
exception
when others then
raise;
end;
exception
when others then
DBMS_OUTPUT.PUT_LINE(sqlerrm || chr(10) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
end; ORA-01403: no data found ORA-06512: at line 10 ORA-06512: at line 7