MySQL Forums
Forum List  »  MySQL Query Browser

Can't select stored procedure OUT param from Query Browser
Posted by: David Sadler
Date: November 30, 2009 07:46PM

Calling the SP (with IN and OUT params) and selecting back the OUT param from the MySQL Command Line Client works as expected.

Calling the SP (with IN and OUT params) and selecting back the result from the MySQL Query Browser does not work as expected. The select result is always NULL.
_________________________________
FROM THE Command Line Client ...

mysql> call sp_project_count(1,@p_count);
Query OK, 0 rows affected (0.00 sec)

mysql> select @p_count;
+----------+
| @p_count |
+----------+
| 4 |
+----------+
1 row in set (0.00 sec)

The select returns the expected value.

____________________________________
FROM THE Query Browser ...

call sp_project_count(1,@p_count);
SELECT @p_count;

The select returns a NULL.

The online SQL Query Browser documentation does not show an example of calling a procedure with IN and OUT params and then selecting back the OUT param.

What am I doing wrong from the Query Browser?

Thanks,
David

Options: ReplyQuote


Subject
Written By
Posted
Can't select stored procedure OUT param from Query Browser
November 30, 2009 07:46PM


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.