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?
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;
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).