|
| Re: debugging stored procedures |
 |
23 Mar 2008 17:27:10 -0700 |
Magnus S. Petersen wrote:
> How can i debug a stored procedure ?
I think you are asking if there is a debugger for stored procedures and
the answer is no. If all else fails you can add a table with a
VARCHAR(80) field to your database and insert debugging messages into
the table from your stored proc.
--
|
| Post Reply
|
| Re: debugging stored procedures |
 |
23 Mar 2008 19:45:09 -0700 |
Magnus S. Petersen wrote:
> Is there really no way to debug ?
There is no interactive debugging tool, which, I presume is what you
are looking for.
--
|
| Post Reply
|
| Re: debugging stored procedures |
 |
Sun, 23 Mar 2008 22:27:04 -040 |
"Magnus S. Petersen" <magnus@post.olivant.fo> wrote in message
news:47e6fcbc$1@newsgroups.borland.com...
> I can manage rather simple procedures but the complicated ones i want to
> monitor how they execute step by step.
> Is there really no way to debug ?
A few of the 3rd party tools available for InterBase attempt to provide
debugging and honestly try to do a good job, but they are doing it
essentially by *guessing* since InterBase provides no debugging hooks. In
most cases this will work, however in those cases where the emulator guesses
wrong, it is *far* worse than having no debugging.
I got steamed once several years ago when a co-worker spent most of an
entire day trying to figure out what was wrong with his proc because the
tool kept indicating a false error. I brought up isql, executed his proc,
and it worked perfectly fine. Because of that I have refused to use any such
tool.
Generally I test by constructing test data and identiifying expected
results, then run the proc and check the results. If I have a problem and
cannot seem to figure it out, I add statements in the proc to dump various
info to a debig table.
--
Wayne Niddery - TeamB (www.teamb.com)
Winwright, Inc. (www.winwright.ca)
|
| Post Reply
|
| debugging stored procedures |
 |
Sun, 23 Mar 2008 23:31:11 -000 |
How can i debug a stored procedure ?
Regards
Magnus
|
| Post Reply
|
| Re: debugging stored procedures |
 |
Mon, 24 Mar 2008 00:58:38 -000 |
Thank you for speedy answer
A little explanation.
I am working with Codegear RAD Studio 2007 Enterprise and InterBase 2007. I
am redesigning an older application for Windows
and trying to move some select queries to stored procedures.
I can manage rather simple procedures but the complicated ones i want to
monitor how they execute step by step.
Is there really no way to debug ?
Thanks in advance
Magnus
"Bill Todd [TeamB]" <no@no.com> skrev i en meddelelse
news:47e6f55e$1@newsgroups.borland.com...
> Magnus S. Petersen wrote:
>
>> How can i debug a stored procedure ?
>
> I think you are asking if there is a debugger for stored procedures and
> the answer is no. If all else fails you can add a table with a
> VARCHAR(80) field to your database and insert debugging messages into
> the table from your stored proc.
>
> --
> Bill Todd (TeamB)
|
| Post Reply
|
|
|
|
|
|
|
|
|
|