MySQL Forums
Forum List  »  Stored Procedures

SYNTAX ERROR IN STORED PROCEDURES DURING MIGRATION
Posted by: ujvala ujvala
Date: November 10, 2005 11:26PM

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 HAS NOT BEEN SUPPORTED BY MYSQL MIGRATION TOOL KIT. IT IS RISING THE ERROR ---

"CHECK YOUR MANUAL FOR THE RIGHT SYNTAX FOR USING NEAR `DECLARE`"


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;


one more thing i want to tell is that i posted this question here, since it is the issue relating the stored procedures and even when i posted the same in migration forum, then i was suggested to post in this forum.

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

THANX IN ADVANCE

UJVALA

Options: ReplyQuote


Subject
Views
Written By
Posted
SYNTAX ERROR IN STORED PROCEDURES DURING MIGRATION
2126
November 10, 2005 11:26PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.