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 @p0='s2'; CALL `proc`(@p0, @p1); SELECT @p1 AS`y'
snumberpnumberjnumberqty Edit Copy Deletes2p1j2120 Edit Copy Deletes2p2j1200 Edit Copy Deletes2p2j2200 Edit Copy Deletes2p3j1200 Edit Copy Deletes3p2j1600 Edit Copy Deletes6p3j20
DROP PROCEDURE `proc;
CREATE DEFINER=`root`@`localhost` PROCEDURE `proc`(IN `x` VARCHAR(3), OUT `y` INT) NOT DETERMINISTIC NO SQL SQL SECURITY DEFINER
BEGIN
DECLARE A_SNUMBER VARCHAR(3);
DECLARE FOUND BOOLEAN DEFAULT TRUE;
DECLARE CURSOR_SUPPLIER_NUMBER CURSOR FOR
SELECT snumber
FROM spj
WHERE snumber = x;
DECLARE CONTINUE HANDLER FOR NOT FOUND
SET FOUND = FALSE;
SET y =0;
OPEN CURSOR_SUPPLIER_NUMBER;
FETCH CURSOR_SUPPLIER_NUMBER INTO A_SNUMBER;
WHILE FOUND DO
SET y= y+1;
FETCH CURSOR_SUPPLIER_NUMBER INTO A_SNUMBER;
END WHILE;
CLOSE CURSOR_SUPPLIER_NUMBER;
END

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!