Subject Messages in triggers and stored procedures
Author W O
Hello everybody

Is there a way to know what a trigger or a stored procedure is doing?

I'll try to explain it better: in a language like Delphi, C, C++, etc., I
can put a message box inside a procedure or function, so I can know the
value of a variable or the line of code which is being executed.

As an example, at run-time the message box can display something like that:
"Function CalculateAge(), line 5, Date=06/09/2010"

Is there a way to do that in a trigger or stored procedure? Can I know, at
run-time, which line of code is being executed?

Thanks very much.

Walter.


[Non-text portions of this message have been removed]