What is a procedure?

Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.

What is a procedure?

Rating:

A procedure is a named PL/SQL block that can accept parameters (sometimes referred to as arguments) and be invoked. Generally, a procedure is used to perform an action. A procedure has a header, a declaration section, an executable section, and an optional exception-handling section. A procedure may or may not return values to its calling environment.

A procedure can be compiled and stored in the database as a schema object for repeated execution. A procedure stored in the database is referred to as a stored procedure. Procedures promote reusability and maintainability. When validated, they can be used in any number of applications. If the functional requirements of the application change, only the procedure needs to be updated.

Rating: