unable to get OUT parameter in a stored procedure[SOLVED]
Posted: Sat Apr 22, 2006 4:42 am
I have a simple stored procedure, which finds a square root, if the resultant value is less than two, I assign it as 'less than two' and if greater than two, I assign it as 'greater than two'.
It also has an OUT parameter.
problems:
1. I am not able to get the OUT parameter.
It also has an OUT parameter.
problems:
1. I am not able to get the OUT parameter.
Code: Select all
CREATE PROCEDURE `test`.`findSquareRoot`(m_inputNumber int, OUT out_number float)
deterministic
BEGIN
declare m_result float;
declare message text;
set m_result = power(m_inputNumber, 1/2);
set out_number = power(m_inputNumber, 1/2);
if (out_number < 2) then
set message = 'number less than two';
else
set message = 'number >= two';
end if;
select message;
END;
result:
mysql> call findSquareRoot(6, @new_out_value);
+---------------+
| message |
+---------------+
| number >= two |
+---------------+
1 row in set
mysql> select @new_out_value;
+----------------+
| @new_out_value |
+----------------+
| NULL |
+----------------+
1 row in set