What Is A Procedure?

1.	What Is A Procedure?
Answer» A procedure is a named program UNIT. It consists of three parts: Declaration PART - Defining the procedure name, CALLING parameters, local variables and local procedures. Declaration part is required. Execution Part - Defining execution logic with executable statements. Execution part is required. Exception Part - Defining error handling LOGICS. Exception part is OPTIONAL. Here how a complete procedure should look like: PROCEDURE name (parameter_1, parameter_2) AS -- Declaration statements BEGIN -- Executable statements EXCEPTION -- Error handling statements END; A procedure is a named program unit. It consists of three parts: Here how a complete procedure should look like:

Answer»

A procedure is a named program UNIT. It consists of three parts:

Declaration PART - Defining the procedure name, CALLING parameters, local variables and local procedures. Declaration part is required.
Execution Part - Defining execution logic with executable statements. Execution part is required.
Exception Part - Defining error handling LOGICS. Exception part is OPTIONAL.

Here how a complete procedure should look like:

PROCEDURE name (parameter_1, parameter_2) AS -- Declaration statements BEGIN -- Executable statements EXCEPTION -- Error handling statements END;

A procedure is a named program unit. It consists of three parts:

Here how a complete procedure should look like:

Discussion