|
Replies:
2
-
Pages:
1
-
Last Post:
Dec 20, 2011 3:46 PM
by: Mauritz
|
Threads:
[
Previous
|
Next
]
|
|
Posts:
1
Registered:
3/14/11
|
|
|
|
Error while trying to debug a stored procedure
Posted:
Mar 18, 2011 9:47 AM
|
|
|
|
|
I am getting this error while debugging my stored procedure. Is anyone else having this issue? I am using MySQL 5.0.90 and using Toad for MySQL 5.0.0.345
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CALL questsoftware.DEBUGSET(l_date,`L`,l_date);...
|
|
|
Posts:
2
Registered:
12/20/11
|
|
|
|
Re: Error while trying to debug a stored procedure
Posted:
Dec 20, 2011 3:13 PM
in response to: MVerdugo
|
|
|
I have encountered the same error with Toad 6.0.1.1723. Few users have reported this problem in the beginner area. From what I have seen, Toad inserts its own statement in the middle of the user's DECLARE CURSOR statement (in both PROCEDURE and FUNCTION) causing SQL error. Does anyone have a workaround? Thank you.
|
|
|
Posts:
313
Registered:
8/23/07
|
|
|
|
Re: Error while trying to debug a stored procedure
Posted:
Dec 20, 2011 3:46 PM
in response to: Seeker
|
|
|
Did not know about this issue. Will create a CR for it to fix in a future release.
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
