跪求大神指导 ERROR 1064 (42000)

[adobe2000]

drop PROCEDURE if exists prc_track_week_delete;
create PROCEDURE prc_track_week_delete()
BEGIN
declare v_starttime datetime default now();
declare v_endtime datetime default now();


declare exit handler for NOT FOUND begin end;
declare exit handler for SQLEXCEPTION call prc_log(v_starttime,'prc_track_week_delete', 'error','');

TRUNCATE table g.ia_track_week;
commit;
END;
-------------------------------------
ERROR 1064 (42000): 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 '' at line 3
在mysql 版本为5.5.16上可以运行，在5.5.8上就运行出错，求指导

[ACMAIN_CHM]

drop PROCEDURE if exists prc_track_week_delete;
DELIMITER //
create PROCEDURE prc_track_week_delete()
BEGIN
declare v_starttime datetime default now();
declare v_endtime datetime default now();


declare exit handler for NOT FOUND begin end;
declare exit handler for SQLEXCEPTION call prc_log(v_starttime,'prc_track_week_delete', 'error','');

TRUNCATE table g.ia_track_week;
commit;
END;
//

[adobe2000]

[Quote=引用 1 楼 的回复:]

drop PROCEDURE if exists prc_track_week_delete;
DELIMITER //
create PROCEDURE prc_track_week_delete()
BEGIN
declare v_starttime datetime default now();
declare v_endtime datetime default now();
……
[/Quote]
多的那两行干嘛用的啊？

[rucypli]

以为mysql会默认遇到;就表示结束 所以需要把默认的；改成//