Win a copy of The Way of the Web Tester: A Beginner's Guide to Automating Tests this week in the Testing forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

mysql cursor in stored procedure

Shilpa Tendulkar
Ranch Hand
Posts: 75
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

Thank you.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic