Page 127 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

-- Output the current row data
SELECT emp name value AS OutputName;
END LOOP;
-- Close the cursor
CLOSE cursor employee;

END //
DELIMITER ;

7 CALL THE STORED PROCEDURE –
Now, call the stored procedure to execute the cursor
CALL DisplayEmployeeNames();

You should see the employee names printed as output.

1 Explain the concept of cursor parameters and provide an example of a stored procedure that uses input
parameters to filter the result set retrieved by a cursor.

112
CITS : IT & ITES - Computer Software Application - Exercise 34