DBE_UTILITY

Interface Description

Table 1 provides all interfaces supported by the DBE_UTILITY package.

• DBE_UTILITY.FORMAT_ERROR_BACKTRACE

The stored procedure FORMAT_ERROR_BACKTRACE returns the call stack where an error occurs during execution. The DBE_UTILITY.FORMAT_ERROR_BACKTRACE function prototype is as follows:

1
2

DBE_UTILITY.FORMAT_ERROR_BACKTRACE()
RETURN TEXT;

• DBE_UTILITY.FORMAT_ERROR_STACK

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

1
2

DBE_UTILITY.FORMAT_ERROR_STACK()
RETURN TEXT;

• DBE_UTILITY.FORMAT_CALL_STACK

The stored procedure FORMAT_CALL_STACK sets the call stack of the output function. The DBE_UTILITY.FORMAT_CALL_STACK function prototype is as follows:

1
2

DBE_UTILITY.FORMAT_CALL_STACK()
RETURN TEXT;

• DBE_UTILITY.GET_TIME

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

1
2

DBE_UTILITY.GET_TIME()
RETURN BIGINT;

Example

 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;
/