Re: stored procedure not working

[Andrew Gilfrin]

Works for me...

mysql> create procedure helloprocedure(OUT param1 VARCHAR(100))
-> begin
-> set param1 = 'Hello World';
-> end
-> //
Query OK, 0 rows affected (0.03 sec)

mysql> call helloprocedure(@a)//

Query OK, 0 rows affected (0.03 sec)

mysql> select @a//

+-------------+
| @a |
+-------------+
| Hello World |
+-------------+
1 row in set (0.00 sec)

Andrew Gilfrin
------------------
http://gilfster.blogspot.com
My MySQL related Blog

http://www.mysqldevelopment.com
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information