|
Replies:
0
-
Pages:
1
|
|
|
Posts:
2
Registered:
7/5/11
|
|
|
|
Debugger
Posted:
Jul 7, 2011 12:34 AM
|
|
|
|
|
Hi all,
when i try to debug procedure i got this error!!
any idea?
this is the procedure, and attach the image that explain the error
thanks
DROP PROCEDURE IF EXISTS actadb8.aggiorna_nuovo_id;
CREATE PROCEDURE actadb8.`aggiorna_nuovo_id`()
BEGIN
DECLARE sAic varchar(10);
DECLARE sNewId varchar(10);
DECLARE no_more_rows varchar(1);
DECLARE listUte CURSOR FOR
SELECT MIN(t2.id), t2.aic FROM pippo AS t2 GROUP BY t2.aic;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET no_more_rows = '1';
SET no_more_rows = '0';
OPEN listUte;
REPEAT
FETCH listUte INTO sNewId, sAic;
UPDATE pippo AS p
SET new_id = sNewId
WHERE p.aic = sAic;
UNTIL no_more_rows = '1'
END REPEAT;
CLOSE listUte;
END;
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
