Extracts diagnostic information about the execution of the
previous SQL statement or SQL routine environment.
The GET DIAGNOSTICS statement captures diagnostic information
from an Oracle Rdb maintained data structure called the
diagnostics area. In the ANSI/ISO SQL standard, the diagnostics
area consists of two components: a single header area and an
array of detail areas. Oracle Rdb extracts information only from
the header component and the first element of the detail area
(Exception 1):
o Header area
Contains status information about rows and transactions, for
example, the number of rows affected by an INSERT, UPDATE, or
DELETE statement or the type of transaction that is active.
See the statement-item-name argument for a complete list of
the status information you can retrieve from the header area.
o Detail area (Exception 1)
Contains diagnostic information that corresponds to the status
that would be reported in the SQLSTATE or SQLCODE status
parameter. The EXCEPTION . . . RETURNED_SQLSTATE argument
retrieves the SQLSTATE status information from the detail
area. The EXCEPTION . . . RETURNED_SQLCODE argument retrieves
the SQLCODE status information from the detail area.
Additional Information:
explode
extract