Diagnostic statements

Routine (Stored Procedure and UDF)

SQL statement	Function
GET DIAGNOSTICS	Output diagnostic information about a statement
SIGNAL	Report exception in routine
RESIGNAL	Report exception in local exception routine

Table 48: SQL statements for procedures