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?