Question: How to trace by hand Given the spj table and the stored procedure below what is the output for SET @p 0 = ' s
How to trace by hand
Given the spj table and the stored procedure below what is the output for
SET @ps; CALL proc@p @p; SELECT @p ASy
snumberpnumberjnumberqty Edit Copy Deletespj Edit Copy Deletespj Edit Copy Deletespj Edit Copy Deletespj Edit Copy Deletespj Edit Copy Deletespj
DROP PROCEDURE proc;
CREATE DEFINERroot@localhost PROCEDURE procIN x VARCHAR OUT y INT NOT DETERMINISTIC NO SQL SQL SECURITY DEFINER
BEGIN
DECLARE ASNUMBER VARCHAR;
DECLARE FOUND BOOLEAN DEFAULT TRUE;
DECLARE CURSORSUPPLIERNUMBER CURSOR FOR
SELECT snumber
FROM spj
WHERE snumber x;
DECLARE CONTINUE HANDLER FOR NOT FOUND
SET FOUND FALSE;
SET y ;
OPEN CURSORSUPPLIERNUMBER;
FETCH CURSORSUPPLIERNUMBER INTO ASNUMBER;
WHILE FOUND DO
SET y y;
FETCH CURSORSUPPLIERNUMBER INTO ASNUMBER;
END WHILE;
CLOSE CURSORSUPPLIERNUMBER;
END
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
