hi
i am using backend as mysql server . In that i am using stored procedure and cursor but her my select query cannot execute for last record in table .here attach my code
i have table in three record when execute the procedure only two record execute
SELECT tech_type INTO check_type1 FROM vendor_tech WHERE tech_type ='CORE' AND v_id=current_vendor_id;
SELECT tech_type INTO check_type2 FROM vendor_tech WHERE tech_type ='FRONTEND' AND v_id=current_vendor_id;
SELECT tech_type INTO check_type3 FROM vendor_tech WHERE tech_type ='FRONTEND' AND v_id=current_vendor_id;
when i remove
INTO check_type1,
INTO check_type2 ,
INTO check_type3 this option execute all record please give me a solution to solve this
gowthaman8870226416