Cross Posted Here with no replies.
http://forums.mysql.com/read.php?108...714#msg-174714
I'm just starting out with MySQL and have an issue with the Query Browser. I have created a simple stored procedure.
From the Command line I Call the procedure and assign a variable to the results.DELIMITER $$ DROP PROCEDURE IF EXISTS `crashcourse`.`ordertotal` $$ CREATE DEFINER=`root`@`localhost` PROCEDURE `ordertotal`( IN onumber INT, OUT ototal DECIMAL(8,2) ) BEGIN SELECT Sum(item_price*quantity) FROM orderitems WHERE order_num = onumber INTO ototal; END $$ DELIMITER ;
mysql> CALL ordertotal(20005, @total);
Query OK, 0 rows affected (0.00 sec)
mysql> SELECT @total;
+--------+
| @total |
+--------+
| 149.87 |
+--------+
1 row in set (0.00 sec)
mysql>
However when I call the procedure in the Query Browser the resultset returns null.
Is there something I'm missing or doing wrong?
Query Browser Version is 1.2.12
MySQL Version is 5.0.45
OS is Vista Business and XP