Hi,
I have observed few things in Ecplise Gynamade
when we run stored procedure in Eclipse, It will give syntax error, the same stored procedure when excuted using in the Toad or DBViusalizer , it works perfectly
Example :
CREATE PROCEDURE TestProcedure(IN parameter1 VARCHAR(4), IN parameter2 TEXT)
BEGIN
DECLARE p1 INT DEFAULT 1;
END
when we excute the same procedure using Ecplise, we get the syntax error,
When we excute the same procedure using DBVisualizer, It works fine.
Solution :
So, Don't waste time on excuting the stored procedure in Eclipse. :-)
Regards,
DeepthiMahesh.
No comments:
Post a Comment