Re: Call and Out Parameters

[Andrew Gilfrin]

You can also use user variables to pass in and return out values in a single parameter.

CREATE PROCEDURE inoutparams (INOUT mymessage VARCHAR(15))
BEGIN

set mymessage = 'Coming Out';

END


set @a = 'Going In';
select @a;
+--------------+
| @a |
+--------------+
| Going In |
+--------------+
1 row in set (0.00 sec)

call inoutparams(@a);

select @a;
+--------------+
| @a |
+--------------+
| Coming Out |
+--------------+
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