[Solved] Identify the error in the following procedure:CREATE PROCEDURE AddNumbers(IN a INT, IN b INT) BEGIN SET sum = a + b; END; | SQL

SQL - Stored Procedures and Functions

Identify the error in the following procedure:

CREATE PROCEDURE AddNumbers(IN a INT, IN b INT)
BEGIN
  SET sum = a + b;
END;

AMissing parentheses after procedure name

BIncorrect keyword 'IN' for parameters

CVariable 'sum' is not declared before use

DMissing semicolon after BEGIN

Step-by-Step Solution

Solution:

Step 1: Check variable usage inside procedure
The variable 'sum' is used without declaration or definition inside the procedure.
Step 2: Understand variable declaration rules
Local variables must be declared with DECLARE before use inside BEGIN-END block.
Final Answer:
Variable 'sum' is not declared before use -> Option C
Quick Check:
Declare variables before SET inside procedures [OK]

Quick Trick: Declare variables before using SET inside procedures [OK]

Common Mistakes:

Master "Stored Procedures and Functions" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Identify the error in the following procedure: