1312 - PROCEDURE logininformation.yearly can't return a result set in the given context

Hai all,

I have created and executed a procedure in following version of WAMP SERVER

MySQL

Server: localhost (localhost via TCP/IP)
Server version: 5.5.8-log
Protocol version: 10
User: root@localhost
MySQL charset: UTF-8 Unicode (utf8)

Web server

Apache/2.2.17 (Win32) PHP/5.3.5
MySQL client version: mysqlnd 5.0.7-dev - 091210 - $Revision: 304625 $
PHP extension: mysqli

I tried to execute following version

MySQL

Server: Localhost via UNIX socket
Server version: 5.0.22
Protocol version: 10
User: logininformation@localhost
MySQL charset: UTF-8 Unicode (utf8)

Web server

Apache/2.2.3 (Red Hat)
MySQL client version: 5.1.30
PHP extension: mysql

My Procedure is

DROP PROCEDURE IF EXISTS  r_yearly;
DELIMITER $$;
CREATE DEFINER='root'@'localhost' PROCEDURE r_yearly(year int)
BEGIN

drop table if exists leavedetails_yearlyreport;

create temporary table leavedetails_yearlyreport(
empid varchar(10),
firstname varchar(30),
month_jan decimal(3,1),
month_feb decimal(3,1),
month_mar decimal(3,1),
month_apr decimal(3,1),
month_may decimal(3,1),
month_jun decimal(3,1),
month_jul decimal(3,1),
month_aug decimal(3,1),
month_sep decimal(3,1),
month_oct decimal(3,1),
month_nov decimal(3,1),
month_dec decimal(3,1));

insert into leavedetails_yearlyreport( 
select e.empid,e.firstname,
round((select acutal_daysofworking from actualworkingdays
where actual_year=year
and actual_month=01)
-
(if((select count(workingstatus) from signin_signout s
where year(signindate)=year
and month(signindate)=01
and workingstatus='F'
and s.empid=e.empid
group by empid)>0,(select count(workingstatus) from signin_signout s
where year(signindate)=year
and month(signindate)=01
and workingstatus='F'
and s.empid=e.empid
group by empid),0) 
+
if((select count(workingstatus)/2 from signin_signout s
where year(signindate)=year
and month(signindate)=01
and workingstatus='H'
and s.empid=e.empid
group by empid)>0,(select count(workingstatus)/2 from signin_signout s
where year(signindate)=year
and month(signindate)=01
and workingstatus='H'
and s.empid=e.empid
group by empid),0)),1)

As jan ,

round((select acutal_daysofworking from actualworkingdays
where actual_year=year
and actual_month=02)
-
(if((select count(workingstatus) from signin_signout s
where year(signindate)=year
and month(signindate)=02
and workingstatus='F'
and s.empid=e.empid
group by empid)>0,(select count(workingstatus) from signin_signout s
where year(signindate)=year
and month(signindate)=02
and workingstatus='F'
and s.empid=e.empid
group by empid),0) 
+
if((select count(workingstatus)/2 from signin_signout s
where year(signindate)=year
and month(signindate)=02
and workingstatus='H'
and s.empid=e.empid
group by empid)>0,(select count(workingstatus)/2 from signin_signout s
where year(signindate)=year
and month(signindate)=02
and workingstatus='H'
and s.empid=e.empid
group by empid),0)),1)

As feb,

round((select acutal_daysofworking from actualworkingdays
where actual_year=year
and actual_month=03)
-
(if((select count(workingstatus) from signin_signout s
where year(signindate)=year
and month(signindate)=03
and workingstatus='F'
and s.empid=e.empid
group by empid)>0,(select count(workingstatus) from signin_signout s
where year(signindate)=year
and month(signindate)=03
and workingstatus='F'
and s.empid=e.empid
group by empid),0) 
+
if((select count(workingstatus)/2 from signin_signout s
where year(signindate)=year
and month(signindate)=03
and workingstatus='H'
and s.empid=e.empid
group by empid)>0,(select count(workingstatus)/2 from signin_signout s
where year(signindate)=year
and month(signindate)=03
and workingstatus='H'
and s.empid=e.empid
group by empid),0)),1)

As mar,

round((select acutal_daysofworking from actualworkingdays
where actual_year=year
and actual_month=04)
-
(if((select count(workingstatus) from signin_signout s
where year(signindate)=year
and month(signindate)=04
and workingstatus='F'
and s.empid=e.empid
group by empid)>0,(select count(workingstatus) from signin_signout s
where year(signindate)=year
and month(signindate)=04
and workingstatus='F'
and s.empid=e.empid
group by empid),0) 
+
if((select count(workingstatus)/2 from signin_signout s
where year(signindate)=year
and month(signindate)=04
and workingstatus='H'
and s.empid=e.empid
group by empid)>0,(select count(workingstatus)/2 from signin_signout s
where year(signindate)=year
and month(signindate)=04
and workingstatus='H'
and s.empid=e.empid
group by empid),0)),1)

As apr,

round((select acutal_daysofworking from actualworkingdays
where actual_year=year
and actual_month=05)
-
(if((select count(workingstatus) from signin_signout s
where year(signindate)=year
and month(signindate)=05
and workingstatus='F'
and s.empid=e.empid
group by empid)>0,(select count(workingstatus) from signin_signout s
where year(signindate)=year
and month(signindate)=05
and workingstatus='F'
and s.empid=e.empid
group by empid),0) 
+
if((select count(workingstatus)/2 from signin_signout s
where year(signindate)=year
and month(signindate)=05
and workingstatus='H'
and s.empid=e.empid
group by empid)>0,(select count(workingstatus)/2 from signin_signout s
where year(signindate)=year
and month(signindate)=05
and workingstatus='H'
and s.empid=e.empid
group by empid),0)),1)

As may,

round((select acutal_daysofworking from actualworkingdays
where actual_year=year
and actual_month=06)
-
(if((select count(workingstatus) from signin_signout s
where year(signindate)=year
and month(signindate)=06
and workingstatus='F'
and s.empid=e.empid
group by empid)>0,(select count(workingstatus) from signin_signout s
where year(signindate)=year
and month(signindate)=06
and workingstatus='F'
and s.empid=e.empid
group by empid),0) 
+
if((select count(workingstatus)/2 from signin_signout s
where year(signindate)=year
and month(signindate)=06
and workingstatus='H'
and s.empid=e.empid
group by empid)>0,(select count(workingstatus)/2 from signin_signout s
where year(signindate)=year
and month(signindate)=06
and workingstatus='H'
and s.empid=e.empid
group by empid),0)),1)

As jun,

round((select acutal_daysofworking from actualworkingdays
where actual_year=year
and actual_month=07)
-
(if((select count(workingstatus) from signin_signout s
where year(signindate)=year
and month(signindate)=07
and workingstatus='F'
and s.empid=e.empid
group by empid)>0,(select count(workingstatus) from signin_signout s
where year(signindate)=year
and month(signindate)=07
and workingstatus='F'
and s.empid=e.empid
group by empid),0) 
+
if((select count(workingstatus)/2 from signin_signout s
where year(signindate)=year
and month(signindate)=07
and workingstatus='H'
and s.empid=e.empid
group by empid)>0,(select count(workingstatus)/2 from signin_signout s
where year(signindate)=year
and month(signindate)=07
and workingstatus='H'
and s.empid=e.empid
group by empid),0)),1)

As jul,

round((select acutal_daysofworking from actualworkingdays
where actual_year=year
and actual_month=08)
-
(if((select count(workingstatus) from signin_signout s
where year(signindate)=year
and month(signindate)=08
and workingstatus='F'
and s.empid=e.empid
group by empid)>0,(select count(workingstatus) from signin_signout s
where year(signindate)=year
and month(signindate)=08
and workingstatus='F'
and s.empid=e.empid
group by empid),0) 
+
if((select count(workingstatus)/2 from signin_signout s
where year(signindate)=year
and month(signindate)=08
and workingstatus='H'
and s.empid=e.empid
group by empid)>0,(select count(workingstatus)/2 from signin_signout s
where year(signindate)=year
and month(signindate)=08
and workingstatus='H'
and s.empid=e.empid
group by empid),0)),1)

As Aug,

round((select acutal_daysofworking from actualworkingdays
where actual_year=year
and actual_month=09)
-
(if((select count(workingstatus) from signin_signout s
where year(signindate)=year
and month(signindate)=09
and workingstatus='F'
and s.empid=e.empid
group by empid)>0,(select count(workingstatus) from signin_signout s
where year(signindate)=year
and month(signindate)=09
and workingstatus='F'
and s.empid=e.empid
group by empid),0) 
+
if((select count(workingstatus)/2 from signin_signout s
where year(signindate)=year
and month(signindate)=09
and workingstatus='H'
and s.empid=e.empid
group by empid)>0,(select count(workingstatus)/2 from signin_signout s
where year(signindate)=year
and month(signindate)=09
and workingstatus='H'
and s.empid=e.empid
group by empid),0)),1)

As sep,

round((select acutal_daysofworking from actualworkingdays
where actual_year=year
and actual_month=10)
-
(if((select count(workingstatus) from signin_signout s
where year(signindate)=year
and month(signindate)=10
and workingstatus='F'
and s.empid=e.empid
group by empid)>0,(select count(workingstatus) from signin_signout s
where year(signindate)=year
and month(signindate)=10
and workingstatus='F'
and s.empid=e.empid
group by empid),0) 
+
if((select count(workingstatus)/2 from signin_signout s
where year(signindate)=year
and month(signindate)=10
and workingstatus='H'
and s.empid=e.empid
group by empid)>0,(select count(workingstatus)/2 from signin_signout s
where year(signindate)=year
and month(signindate)=10
and workingstatus='H'
and s.empid=e.empid
group by empid),0)),1)

As oct,

round((select acutal_daysofworking from actualworkingdays
where actual_year=year
and actual_month=11)
-
(if((select count(workingstatus) from signin_signout s
where year(signindate)=year
and month(signindate)=11
and workingstatus='F'
and s.empid=e.empid
group by empid)>0,(select count(workingstatus) from signin_signout s
where year(signindate)=year
and month(signindate)=11
and workingstatus='F'
and s.empid=e.empid
group by empid),0) 
+
if((select count(workingstatus)/2 from signin_signout s
where year(signindate)=year
and month(signindate)=11
and workingstatus='H'
and s.empid=e.empid
group by empid)>0,(select count(workingstatus)/2 from signin_signout s
where year(signindate)=year
and month(signindate)=11
and workingstatus='H'
and s.empid=e.empid
group by empid),0)),1)

As nov,

round((select acutal_daysofworking from actualworkingdays
where actual_year=year
and actual_month=12)
-
(if((select count(workingstatus) from signin_signout s
where year(signindate)=year
and month(signindate)=12
and workingstatus='F'
and s.empid=e.empid
group by empid)>0,(select count(workingstatus) from signin_signout s
where year(signindate)=year
and month(signindate)=12
and workingstatus='F'
and s.empid=e.empid
group by empid),0) 
+
if((select count(workingstatus)/2 from signin_signout s
where year(signindate)=year
and month(signindate)=12
and workingstatus='H'
and s.empid=e.empid
group by empid)>0,(select count(workingstatus)/2 from signin_signout s
where year(signindate)=year
and month(signindate)=12
and workingstatus='H'
and s.empid=e.empid
group by empid),0)),1)

As dece

from employee e where active='ACTIVE' order by empid

);

select * from leavedetails_yearlyreport order by empid;

end $$

It raising following error

Sorry your method returns far to much code for me to have time to read, so i checked out your error message and found it means this:
from the mysql manual:

Statements that return a result set can be used within a stored procedure but not within a stored function. This prohibition includes SELECT statements that do not have an INTO var_list clause and other statements such as SHOW, EXPLAIN, and CHECK TABLE. For statements that can be determined at function definition time to return a result set, a Not allowed to return a result set from a function error occurs (ER_SP_NO_RETSET). For statements that can be determined only at runtime to return a result set, a PROCEDURE %s can't return a result set in the given context error occurs (ER_SP_BADSELECT).

i have found about a flag called CLIENT_MULTI_RESULTS are you setting this?