ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

TRACEBACK function [Miscellaneous]

Function 

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

Syntax 

TRACEBACK ( * )

Usage 

This is useful for debugging procedures and triggers

Standards and compatibility 

• SQL/92    Transact-SQL extension.

• SQL/99    Transact-SQL extension.

• Sybase    Not supported by Adaptive Server Enterprise.

Example 

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

SELECT TRACEBACK ( * )