MySQL Forums
Forum List  »  Stored Procedures

Re: Call and Out Parameters
Posted by: Andrew Gilfrin
Date: June 24, 2005 02:34AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
3325
June 23, 2005 03:43PM
3211
June 23, 2005 04:25PM
Re: Call and Out Parameters
2463
June 24, 2005 02:34AM
2439
July 01, 2005 07:15AM
2405
July 01, 2005 07:22AM
4842
July 01, 2005 07:38AM


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.