dbTalk Databases Forums  

Error 1329 - No data - zero rows fetched, selected, or processed

comp.databases.mysql comp.databases.mysql


Discuss Error 1329 - No data - zero rows fetched, selected, or processed in the comp.databases.mysql forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
gp
 
Posts: n/a

Default Error 1329 - No data - zero rows fetched, selected, or processed - 05-18-2011 , 08:31 PM






The following code is the basis for all of my stored procedures. I
was running these scripts with no issue and now, they are all throwing
a 1329.
I changed the loop construct and I still get the same error. any
insight or wise words would be appreciated.

Thanks, in advance.

DELIMITER //
DROP PROCEDURE IF EXISTS sp_test//
CREATE PROCEDURE sp_test(IN $id INT, OUT $code INT, OUT $message TEXT)
BEGIN
DECLARE finished INT UNSIGNED DEFAULT 0;

DECLARE $eon_key VARCHAR(10);

DECLARE cur CURSOR FOR
SELECT `key` FROM eon_brands;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET finished = 1;

DECLARE CONTINUE HANDLER FOR 1062
BEGIN
SET $code = 1062;
SET $message = "Something bad happened";
END;

OPEN cur;
curl:REPEAT
FETCH cur INTO $eon_key;
IF NOT finished THEN
SELECT $eon_key;
END IF;
UNTIL finished
END REPEAT curl;

CLOSE cur;

SET $code = 2234;
SET $message = 'WEEEEEEEEE';
END//
DELIMITER ;

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.