Which of the following statements can you add to a stored procedure to provide meaningful feedback to a user who attempts to execute the procedure with an argument that is invalid because it is missing from the table column being queried?
A) DECLARE EXIT HANDLER FOR NOT FOUND
B) DECLARE EXIT HANDLER FOR INVALID ARGUMENT
C) ERROR MESSAGE FOR NOT FOUND
D) ERROR MESSAGE FOR INVALID ARGUMENT

Question

Quizplus · Accepted Answer

The "DECLARE EXIT HANDLER FOR NOT FOUND" statement is used in stored procedures to handle situations where a query does not find any rows that match the criteria. This can be used to provide feedback when an argument provided to the procedure does not match any entries in the table being queried.

Which of the Following Statements Can You Add to a Stored