Subject | Messages in triggers and stored procedures |
---|---|
Author | W O |
Post date | 2010-09-07T09:03:39Z |
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]
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]