Stored Procedure( OUT PARAMETER) CANT CALLED.. HELP ME
Code:
CREATE PROCEDURE get_maxprice(OUT M_TotalPrice DECIMAL(5,2))
BEGIN
SELECT MAX(VALUE) INTO M_TotalPrice
FROM
(
SELECT SUM(subTotal) AS VALUE
FROM CustomerOrder
);
END@
CALL get_maxprice(@11111);
WHY I cant Called the procedure..They said they have error?
Last edited by Rabbit; Jan 6 '14, 07:22 PM.
Reason: Please use [CODE] and [/CODE] tags when posting code or formatted data.
Comment