Hi, Iam looking to migrate an Oracle database to MySQL and trying to write a simple stored procedure in MySQL 4.1 .I reffered few examples posted and used the statements from them but I get errors while creating procedures
create procedure helloworld (out p_text VARCHAR(30)) BEGIN set p_text = "HELLO WORLD" ; END // After pressin enter key an error message is displayed ERROR 1064(42000): you have an erro in your SQL syntax; check the manual that corresponds to your mysql server version for the right syntax t ouse near 'procedure HElloWorld ( OUT p_text = 'HELLO World' ' at line 1 Any help would be appreciated . Thanks, Sreedhar. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
