Types of SPL programs v17
SPL is a procedural, block-structured language. You can create four different types of programs using SPL: procedures, functions, triggers, and packages.
In addition, you can use SPL to create subprograms. A subprogram refers to a subprocedure or a subfunction. These are nearly identical in appearance to procedures and functions. They differ in that procedures and functions are standalone programs. They are stored individually in the database, and you can invoke them from other SPL programs or from PSQL. You can invoke subprograms only from the standalone program where they were created.
basic_spl_elements spl_block_structure anonymous_blocks procedures_overview functions_overview procedure_and_function_parameters subprograms_subprocedures_and_subfunctions compilation_errors_in_procedures_and_functions program_security