Error Code : 1329, No data - zero rows fetched, selected, or processed. MYSQL

[preejith]

Error Code : 1329, No data - zero rows fetched, selected, or processed. MYSQL
I am getting the following error while running a stored procedure in mysql5.0

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

I have an stored procedure SP1 which calls stored procedure SP2 and SP2 calls a function F1.

I have run this script from .bat file.

after executing i tried to call stored procedure 1 (update_stock), it gives error listed top.

But if i open stored procedure from sqlyog by clicking on alter procedure and rerun the stored procedure.

next time when i call the procedure it executes properly with out error.

Please help me with some solution.

The basic structre of procedure and function is given below


For eg.


----- stored procedure 1 -------------

[CODE=mysql]DELIMITER $$;

DROP PROCEDURE IF EXISTS `update_stock`$ $
CREATE PROCEDURE `update_stock`( upload_date varchar(10))
BEGIN

call update_closings tk(upload_date) ;

END$$

DELIMITER ;$$[/CODE]



----- stored procedure 2 -------------

[CODE=mysql]DELIMITER $$;

DROP PROCEDURE IF EXISTS `update_closing stk`$$
CREATE PROCEDURE `update_closing stk`(upload_dat e varchar(10))
BEGIN

declare clsstock int default 0;

set clsstock = get_closing_stk

END$$

DELIMITER ;$$[/CODE]



--- Function 1--------------

[CODE=mysql]DELIMITER $$;

DROP FUNCTION IF EXISTS `scm_db`.`get_c losing_stk`$$

CREATE FUNCTION `get_closing_st k`(upload_date varchar(10),pro ductrid int ,pkt2cbb2 int) RETURNS int(11)
BEGIN
declare closingstock int;
select clsstock into closingstock from clsstk_tab where stk_prod_rid=10 ;

return IFNULL(closings tock ,0);
END$$

DELIMITER ;$$[/CODE]

[MadhusmitaP]

Please change your stored function in the below mentioned way:

---------------------------------------------

DELIMITER $$
DROP FUNCTION IF EXISTS `DEMO`$$
CREATE FUNCTION `DEMO`(upload_d ate varchar(10),pro ductrid int ,pkt2cbb2 int(11))
RETURNS int(11)
BEGIN
declare closingstock int;
select IF(COUNT(clssto ck) > 0, clsstock, 0) into closingstock from clsstk_tab where stk_prod_rid=10 ;

return closingstock;
END $$

DELIMITER

---------------------------------------------

It will solve your problem