DBMS_UTILITY.FORMAT_CALL_STACK and DBMS_UTILITY.FORMAT_ERROR_STACK : dbms_utility « System Packages « Oracle PL/SQL Tutorial

SQL>
SQL>
SQL> CREATE OR REPLACE PROCEDURE error_test1 AS
  2  BEGIN
  3     RAISE VALUE_ERROR;
  4  END error_test1;
  5  /

Procedure created.

SQL> CREATE OR REPLACE PROCEDURE error_test2 AS
  2  BEGIN
  3     error_test1;
  4  EXCEPTION
  5     WHEN OTHERS THEN
  6        DBMS_OUTPUT.PUT_LINE(DBMS_UTILITY.FORMAT_CALL_STACK);
  7        DBMS_OUTPUT.PUT_LINE(DBMS_UTILITY.FORMAT_ERROR_STACK);
  8  END error_test2;
  9  /

Procedure created.

SQL>

31.30.dbms_utility
	31.30.1.	dbms_utility.get_hash_value
	31.30.2.	Use dbms_utility.name_resolve to find a package
	31.30.3.	Use dbms_utility.name_tokenize to split a name
	31.30.4.	Call dbms_utility.db_version to get the version and its compatible version
	31.30.5.	Use dbms_utility.comma_to_table, dbms_utility.table_to_comma to parse comma delimited value
	31.30.6.	Call dbms_utility.get_parameter_value to get the value of utl_file_dir
	31.30.7.	Call dbms_utility.get_time twice
	31.30.8.	Call dbms_utility.analyze_schema analyze schema
	31.30.9.	Assign value from dbms_utility.get_time to a number variable
	31.30.10.	Call dbms_utility.get_time twice to time the insert statement
	31.30.11.	Timing log
	31.30.12.	dbms_utility.format_error_stack
	31.30.13.	DBMS_UTILITY.FORMAT_CALL_STACK and DBMS_UTILITY.FORMAT_ERROR_STACK