Mysql Call Stored procedure from another stored procedure

Question

I am sorry for the incomplete information. Here's my two sp's: SP1 -

DELIMITER $$

DROP PROCEDURE IF EXISTS SP1 $$ CREATE PROCEDURE SP1(InputCustomerID int, InputOrderID int) BEGIN

// Some sql statements and finally put it into the actual table tb1 in the database

END $$

DELIMITER ;

SP2 - In SP2 i am assigning input value of SP1's params.

DELIMITER $$

DROP PROCEDURE IF EXISTS SP2 $$ CREATE PROCEDURE SP2() BEGIN

Declare InputCustomerID int; Declare InputOrderID int; Declare OrderStateDate Datetime;

Select CustomerID into InputCustomerID From Cusomers Where CustomerID NOT IN (Select FK_CustomerID From CustomerOrders) and IsApproved = True and CustomerID IN (Select FK_CustomerID From CustomerProductOrders Where Date (OrderStartDate) = Date(Now()));

Select OrderID into InputOrderID From CustomerOrders Where FK_CustomerID NOT IN (Select FK_CustomerID From CustomerProdcutOrders) and IsApproved = True and Date(OrderStartDate) = Date(Now());

Call SP1(InputCustomerID, InputOrderID);

END $$

DELIMITER ;