Hi I have created a stored procedure which returns few records depend on IN parameter pass to it. Using those records I want to select some data from another table. My problem is this stored proceduer doesnt compile and gives syntax error on line no. 11. Which is -- "DECLARE user_cursor CURSOR ".
complete error is:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DECLARE user_cursor CURSOR FOR SELECT username FROM `user` WHERE distributor_i' at line 11
I am using mysql 5.2.3, Stored procedure is
I am new to stored procedures and cursor. Any help will be highly appreciated.