What is a subprogram?

What is a subprogram?

Rating:

A subprogram is a named PL/SQL block that can accept parameters and be invoked. There are two types of subprograms: procedures and functions. A procedure is generally used to perform an action, and a function is used to compute a value. Subprograms can be stored at the server or application level. By using Oracle Developer components (Forms, Reports, and Graphics), procedures and functions can be declared as part of an application (a form or report) and be called from other procedures, functions, and triggers within the same application whenever necessary.

A function is similar to a procedure, except that a function must return a value to the calling environment, whereas a procedure may or may not return values to its calling environment.

Rating: