PROBLEM IN CREATING LOCAL VARIABLES

[ujvala ujvala]

HELLO ALL,

I COULD NOT ABLE TO CREATE LOCAL VARIABLES IN STORED PROCEDURES DURING "MIGRATION".
GENERALLY WE USE 'DECLARE' KEYWORD FOR CREATION OF VARIABLES IN MYSQL; BUT ITS SCOPE IS BETWEEN 'BEGIN' AND 'END' WHOSE SYNTAX WILL NOT BE SUPPORTED BY MYSQL MIGRATION TOOL KIT.

SO IF THE MIGRATION TOOL KIT SUPPORTS THE SYNTAX OF 'BEGIN' AND 'END', THEN IT IS POSSIBLE TO CREATE VARIABLES IN STORED PROCEDURES.


AND FINALLY MY QUESTION IS :
"IS THERE ANY OTHE ALTERNATIVE TO CREATE LOCAL VARIABLES IN STORED PROCEDURES DURING MIGRATION OF MSSQL TO MYSQL"?

EVEN THE ONLINE HELP SPECIFIED THE SAME WAY :

create procedure bug()
begin
declare a int;

select a;
set a = 1;
select a;
end;


CAN ANYONE COME UP WITH THE SOLUTION? IT WOULD BE MUCH APPRECIATED

THANX IN ADVANCE

UJVALA