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

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
raghavan20
DevNet Resident
Posts: 1451
Joined: Sat Jun 11, 2005 6:57 am
Location: London, UK
Contact:

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

Post 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
Last edited by raghavan20 on Tue Apr 25, 2006 1:46 am, edited 1 time in total.
User avatar
raghavan20
DevNet Resident
Posts: 1451
Joined: Sat Jun 11, 2005 6:57 am
Location: London, UK
Contact:

Post 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.
Post Reply