SQL> DECLARE
2 myException EXCEPTION;
3 FUNCTION innerFunction
4 RETURN BOOLEAN IS
5 retval BOOLEAN := FALSE;
6 BEGIN
7 RAISE myException;
8 RETURN retval;
9 END;
10 BEGIN
11 IF innerFunction THEN
12 dbms_output.put_line('No raised exception');
13 END IF;
14 EXCEPTION
15 WHEN others THEN
16 dbms_output.put_line('DBMS_UTILITY.FORMAT_ERROR_STACK');
17 dbms_output.put_line(dbms_utility.format_error_stack);
18
19 END;
20 /
PL/SQL procedure successfully completed.
SQL>
|