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






  1. Oracle PL/SQL Tutorial
  2. System Packages
  3. dbms_utility
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>








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