DECLARE STATEMENT CAUSING AN ERROR IN PROCEDURE

[expired user #8984]'s profile image [expired user #8984] posted 9 years ago in General Permalink
I can't find the source of the SQL Error (1064) that I'm generating with the statement:
DECLARE @n INT DEFAULT 0 ;

PROCEDURE `tblmkr`(IN `TabsAsk` INT, IN `TabNnm` VARCHAR (6))
LANGUAGE SQL
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT ''
BEGIN
DECLARE @n INT DEFAULT 0 ;
Head: LOOP
SET @ n=@n +1;
** code block for table comparisons omitted during testing
IF @ n < TabsAsk THEN ITERATE Head ; END IF ;
LEAVE Head;
END LOOP Head;
END;
---> SQL Error ( 1064)"check the manual re syntax to use near
'DECLARE @n INT DEFAULT 0;
Head: LOOP
SET @n=@n+1;'


Please login to leave a reply, or register at first.