[Solved] What is wrong with this procedure call?CREATE PROCEDURE proc_example(IN val INT)BEGIN SELECT val;END;CALL proc_example(@output); | SQL

SQL - Stored Procedures and Functions

What is wrong with this procedure call?

CREATE PROCEDURE proc_example(IN val INT)
BEGIN
  SELECT val;
END;

CALL proc_example(@output);

AUser variable @output is not initialized before call.

BCannot pass a user variable to an IN parameter.

CProcedure call syntax is incorrect; missing parentheses.

DIN parameters cannot be used in SELECT statements.

Step-by-Step Solution

Solution:

Step 1: Check variable initialization
@output is used as input but not assigned a value before the call.
Step 2: Validate other options
User variables can be passed, syntax is correct, IN parameters can be selected.
Final Answer:
User variable @output is not initialized before call. -> Option A
Quick Check:
Initialize variables before passing [OK]

Quick Trick: Always initialize variables before procedure call [OK]

Common Mistakes:

Master "Stored Procedures and Functions" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

What is wrong with this procedure call?