WampServer

hi all,

I am trying to create a simple procedure with cursor that will return a single record. But i m getting maximum time limit exceeded error. The time limit in my php.ini is 300. If i execute the same query without procedures, i am getting result within a fraction of sec. Am i doin anything wrong?

delimiter \\
create procedure expr_date()
begin
declare certification_name varchar(100);
declare completion_status varchar(25);
declare completion_date varchar(15);

declare cur_expr cursor for select certification_name, status,date_of_completion from certification_data where emp_id=4372 and certification_name="Data Protection";

DECLARE CONTINUE HANDLER FOR NOT FOUND
SET no_more_products = 1;

open cur_expr;
fetch cur_expr into cert_name, completion_status,completion_date;
select cert_name, completion_status,completion_date;
close cur_expr;
end \\
delimiter;


Any help is appreciated.

Thanks in advance.

hi all,

i tried this procedure in mysql console and it is working fine. the problem is when I try to create it using phpmyadmin. i have changed the time limit in config.inc php as 0(for max limit).

Any idea why i am getting this problem?

Thanks in advance.