Returns a string containing a traceback of the procedures and triggers that were executing when the most recent exception (error) occurred.

Syntax

TRACEBACK( * )

Returns

LONG VARCHAR

Remarks

This is useful for debugging procedures and triggers

Standards and compatibility

Example

To use the traceback function, enter the following after an error occurs while executing a procedure:

SELECT TRACEBACK( * );