|
Replies:
1
-
Pages:
1
-
Last Post:
Sep 9, 2010 7:08 AM
by: Zoitc
|
Threads:
[
Previous
|
Next
]
|
|
Posts:
1
Registered:
8/25/10
|
|
|
|
Debugging Mysql Stored Procedures using labels
Posted:
Aug 25, 2010 7:04 AM
|
|
|
|
|
Hello,
i like the possibility to debug stored procedure with Toad.
But there's a problem with the use of labels.
Everytime you use a label into a stored procedure like this:
curLoop: REPEAT
.. make something
ITERATE / LEAVE curLoop;
UNTIL [condition]
END REPEAT;
the procedure cannot be debbuged anymore.
Toad shows an error message like the attached one.
Sometimes helps a little workaround.
To leave a procedure anywhere, you can use the LEAVE [label].
For this i mark the outer Block with a label.
To make this anyway debugable i noticed that the following runs:
BEGIN
main:BEGIN
.
.
.
END main;
END;
Anyone who has an idea about this problem?
Thanks
Sven
|
|
|
Posts:
1
Registered:
9/9/10
|
|
|
|
Re: Debugging Mysql Stored Procedures using labels
Posted:
Sep 9, 2010 7:06 AM
in response to: Sven G
|
 |
Helpful |
|
|
I use for debugging, dbForge Studio for MySQL. In dbForge no such problems. It stable, not buggy, excellent functionality.
Message was edited by: Zoitc
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
