Given the following stored procedure:
CREATE PROCEDURE increase_salary ( IN p_workdept CHAR(6),
OUT p_sum DECIMAL(9,2) )
SET p_sum = (SELECT SUM(salary) FROM employee WHERE workdept=p_workdept);
How can this stored procedure be called from the Command Line Processor?
A.
CALLincrease_salary(‘A00’)
B.
VALUESincrease_salary(‘A00’)
C.
CALLincrease_salary(‘A00’, ?)
D.
VALUESincrease_salary(‘A00’, ?)