MySQL Forums
Forum List  »  General

lost connection during UDF call
Posted by: Dániel Drótos
Date: September 26, 2004 11:51AM

Hi,

Using 5.0.1 when I cal a stored procedure I got
ERROR 2013 (HY000): Lost connection to MySQL server during query
The procedure is:

CREATE PROCEDURE `iccc2005`.`del_material`(in mid int)
SQL SECURITY INVOKER
begin
declare done int default 0;
declare lid int;
declare lids cursor for select lid from lecture where material=mid;
declare continue handler for sqlstate '02000' set done = 1;
open lids;
repeat
fetch lids into lid;
if not done then
delete from lecture_presenters where lecture=lid;
end if;
until done end repeat;
close lids;
end

What does connection loosing means? Wrong/illegal code in UDF? Bug in server?

Options: ReplyQuote


Subject
Written By
Posted
lost connection during UDF call
September 26, 2004 11:51AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.