Creating a subfunction v16
FUNCTION clause specified in the declaration section defines and names a subfunction local to that block.
The term block refers to the SPL block structure consisting of an optional declaration section, a mandatory executable section, and an optional exception section. Blocks are the structures for standalone procedures and functions, anonymous blocks, subprograms, triggers, packages, and object type methods.
The phrase the identifier is local to the block means that the identifier (that is, a variable, cursor, type, or subprogram) is declared in the declaration section of that block and is therefore accessible by the SPL code in the executable section and optional exception section of that block.
nameis the identifier of the subfunction.
parametersis a list of formal parameters.
data_typeis the data type of the value returned by the function’s
PRAGMA AUTONOMOUS_TRANSACTIONis the directive that sets the subfunction as an autonomous transaction.
declarationsare variable, cursor, type, or subprogram declarations. If subprogram declarations are included, they must be declared after all other variable, cursor, and type declarations.
statementsare SPL program statements. The
BEGIN - ENDblock can contain an
This example shows the use of a recursive subfunction:
The following is the output: