How can I retrieve an SQL-statement which ended in error

mar01 · #1 (**permalink**) 02-25-09, 05:37

I have defined an exit handler in a stored procedure and now I want to store the SQL-statement in error in a table. How can I retrieve the SQL-statement which ended in error

mar01 · #2 (**permalink**) 02-25-09, 05:38

Retrieve SQL-statement which ended in error

ARWinner · #3 (**permalink**) 02-25-09, 09:03

The easiest way I can think of is before you execute a SQL statement, store it in a variable. Then in the error handler, the contents of that variable will be the offending statement to do with what you want.

Andy

Internet Services

Web Development

Digital Marketing

Consumer Tech