Stored Procedure( OUT PARAMETER) CANT CALLED.. HELP ME

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • RESHA
    New Member
    • Jan 2014
    • 1

    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.
  • Anas Mosaad
    New Member
    • Jan 2013
    • 185

    #2
    try
    Code:
    CALL get_maxprice(?)
    @

    Comment

    Working...