Process Body Create Script Template

-- ------------------------------------------------------------------------- -- -- -- -- Title: [schema]_[process_name]_b.sql -- -- Author: Steve Roach -- -- Date: DD-MON-YYYY -- -- Version: 01.00 -- -- -- -- Description: Container for all procedures and functions relating to -- -- ... -- -- -- -- History: -- -- -- -- Date Ver Author Description -- -- --------- ----- ------ -------------------------------------------------- -- -- DD-MON-YY 01.00 SRR First release -- -- -- -- ------------------------------------------------------------------------- -- -- Package body definition. CREATE OR REPLACE PACKAGE BODY [schema]_[process_name] AS -- Create globals: [global_1] [DATATYPE]; -- [procedure_1] -- Description. PROCEDURE [procedure_1] ( p_[parameter_1] IN/OUT [DATATYPE] ,... ) IS l_[local_1] [DATATYPE]; ... -- Sub-procedure description. PROCEDURE [sub-proceure_1] ( p_[parameter_1] IN/OUT [DATATYPE] ,... ) IS BEGIN code ... EXCEPTION WHEN ... THEN ... END [sub-proceure_1]; -- Sub-procedure description. PROCEDURE [sub-proceure_1] ... BEGIN code ... EXCEPTION WHEN ... THEN ... END [procedure_1]; -- [procedure_2] -- Description. PROCEDURE [procedure_2] ... END [schema]_[process_name]; / SHOW ERRORS