DBE_UTILITY

APIs

Table 1 provides all APIs supported by the DBE_UTILITY package.

• DBE_UTILITY.FORMAT_ERROR_BACKTRACE

Returns the call stack where an error occurs during execution. The prototype of the DBE_UTILITY.FORMAT_ERROR_BACKTRACE function is as follows:

1
2

DBE_UTILITY.FORMAT_ERROR_BACKTRACE()
RETURN TEXT;

• DBE_UTILITY.FORMAT_ERROR_STACK

Returns the detailed information about the error location when an error occurs during the execution. The prototype of the DBE_UTILITY.FORMAT_ERROR_STACK function is as follows:

1
2

DBE_UTILITY.FORMAT_ERROR_STACK()
RETURN TEXT;

• DBE_UTILITY.FORMAT_CALL_STACK

Sets the call stack of the output function. The prototype of the DBE_UTILITY.FORMAT_CALL_STACK function is as follows:

1
2

DBE_UTILITY.FORMAT_CALL_STACK()
RETURN TEXT;

• DBE_UTILITY.GET_TIME

Sets the output time, which is usually used for difference. A separate return value is meaningless. The prototype of the DBE_UTILITY.GET_TIME function is as follows:

1
2

DBE_UTILITY.GET_TIME()
RETURN BIGINT;

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12

CREATE OR REPLACE PROCEDURE test_get_time1() 
AS
declare
    start_time  bigint;
    end_time  bigint;
BEGIN
    start_time:= dbe_utility.get_time ();
    pg_sleep(1);
    end_time:=dbe_utility.get_time ();
    dbe_output.print_line(end_time - start_time);	
END;
/