MySQL
by simply CALL
query. This query takes the name of the stored procedure and any parameters we need to pass to it. The following is the basic syntax to execute a stored procedure :CALL stored_procedure_name (argument_list);
CALL Product_Pricing (@pricelow, @pricehigh);
Product_Pricing
calculates and returns the lowest and highest product prices.