Page 1 of 1

unable to get OUT parameter in a stored procedure[SOLVED]

Posted: Sat Apr 22, 2006 4:42 am
by raghavan20
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.

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

Posted: Tue Apr 25, 2006 1:46 am
by raghavan20
I was working with a few DB tools and they were not giving me proper results but it worked when I tried from command line.