i am writing a very simple procedure in which i am making a cursor but it is giving me error.
the code is
Code:
DELIMITER $$
DROP PROCEDURE IF EXISTS `cms`.`curDemo` $$
CREATE PROCEDURE `cms`.`curDemo` ()
BEGIN
Declare node cursor for select * from groupView
END $$
DELIMITER ;
and the error is
Code:
Script line: 4 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 'for select * from groupView
END' at line 3
can you people tel me what wrong i am doing ?
dBforums
>
Cursor Errors
09-07-06, 09:27
Linear Mode
