[Solved] Identify the error in this procedure declaration:CREATE PROCEDURE test_proc(OUT val INT, INOUT val INT)BEGIN SET val = val + 1;END; | SQL

SQL - Stored Procedures and Functions

Identify the error in this procedure declaration:

CREATE PROCEDURE test_proc(OUT val INT, INOUT val INT)
BEGIN
  SET val = val + 1;
END;

AParameter names must be unique; 'val' is repeated.

BOUT parameters cannot be used with INOUT parameters.

CProcedure body cannot modify INOUT parameters.

DINT is not a valid data type for parameters.

Step-by-Step Solution

Solution:

Step 1: Check parameter names
Both parameters are named 'val', which is not allowed; names must be unique.
Step 2: Validate other options
OUT and INOUT can coexist, INOUT can be modified, INT is valid type.
Final Answer:
Parameter names must be unique; 'val' is repeated. -> Option A
Quick Check:
Unique parameter names required [OK]

Quick Trick: Parameter names must be unique in procedure [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 this procedure declaration: