MySQL Forums
Forum List  »  Newbie

stored procedure not working
Posted by: Daniel Isaacs
Date: July 29, 2005 05:39AM

I'm trying to Pass Parameters with Procedures

the first query i run is

create procedure helloprocedure(OUT param1 VARCHAR(100))
begin
set param1 = 'Hello World';
end

then i run
call helloprocedure(@a);

and when i run
select @a;

i get
NULL instead of Hello World
is there any reason for that?

Options: ReplyQuote


Subject
Written By
Posted
stored procedure not working
July 29, 2005 05:39AM


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.