[Solved] What is wrong with this procedure declaration?CREATE PROCEDURE calculateSum(a INT, b INT) RETURNS INT AS $ BEGIN RETURN a + b; END; $ LANGUAGE plpgsql; | SQL

SQL - Stored Procedures and Functions

What is wrong with this procedure declaration?

CREATE PROCEDURE calculateSum(a INT, b INT) RETURNS INT AS $$ BEGIN RETURN a + b; END; $$ LANGUAGE plpgsql;

AMissing BEGIN keyword

BParameters must be declared as VARCHAR

CProcedure name is invalid

DProcedures cannot have a RETURNS clause

Step-by-Step Solution

Solution:

Step 1: Check procedure syntax
Procedures do not return values and thus do not have RETURNS clauses.
Step 2: Identify the error
The RETURNS INT clause is invalid for procedures.
Final Answer:
Procedures cannot have a RETURNS clause -> Option D
Quick Check:
Procedures do not return values directly [OK]

Quick Trick: Procedures do not use RETURNS, functions do [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 declaration?