Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
combined spec and body package template
CREATE OR REPLACE PACKAGE BFH2_TEMPLATE
AS
/*
AUTHOR: Joe Developer
PACKAGE NAME: TEMPLATE SPEC
CREATION DATE: MM/DD/YYYY
PURPOSE:
DEPENDENCIES:
CHANGELOG:
DATE DEVELOPER DESCRIPTION
MM-DD-YYYY Joe Developer change description...
ADDITIONAL DOCUMENTATION:
Additional Information about the inner workings of this module.
*/
/*
AUTHOR:Joe Developer
ACCEPTS:These Args
DOES:Performs Function
RETURNS:Return Value
DEPENDENCIES:Uses/Needs
NOTES: Special Considerations
*/
FUNCTION FunName(
InVariable varchar2
)
RETURN number;
END BFH2_TEMPLATE;
/
CREATE OR REPLACE PACKAGE BODY BFH2_TEMPLATE
AS
/*
AUTHOR: Joe Developer
PACKAGE NAME: TEMPLATE BODY
CREATION DATE: MM/DD/YYYY
PURPOSE:
DEPENDENCIES:
CHANGELOG:
DATE DEVELOPER DESCRIPTION
MM-DD-YYYY Joe Developer change description...
ADDITIONAL DOCUMENTATION:
Additional Information about the inner workings of this module.
*/
/*
AUTHOR:Joe Developer
ACCEPTS:These Args
DOES:Performs Function
RETURNS:Return Value
DEPENDENCIES:Uses/Needs
NOTES: Special Considerations
*/
FUNCTION FunName(
InVariable varchar2
)
RETURN number
IS --declaration_section
returnValue number;
BEGIN --executable_section
return returnValue;
EXCEPTION --exception_section
when others
then return -1;
END FunName;
END BFH2_TEMPLATE;
/
--//--//--//--//--//--//--//--//--//--//--//--//--//--//--//--//--//--//--//--//
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.