dbms_utility.format_error_stack : dbms_utility « System Packages « Oracle PL / SQL

dbms_utility.format_error_stack

  

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>

Related examples in the same category

1.	This script demonstrates DBMS_UTILITY.NAME_TOKENIZE.
2.	Use dbms_utility to time
3.	time to commit
4.	dbms_utility.get_parameter_value
5.	Call dbms_utility.get_time twice to time a statement in PL SQL
6.	round dbms_utility.get_time
7.	Assign dbms_utility.get_time to integer variable
8.	Use dbms_utility.get_time to do performace check
9.	Timing Per Thousand Records Processed (in secs)
10.	Timing Package function call
11.	use DBMS_UTILITY.FORMAT_ERROR_STACK in a SERVERERROR trigger.
12.	DBMS_UTILITY.analyze_schema
13.	demonstrates the use of DBMS_UTILITY.TABLE_TO_COMMA and DBMS_UTILITY.COMMA_TO_TABLE.
14.	Performace difference between simple parameter and collection parameter