Skip to content

Instantly share code, notes, and snippets.

@AndrewRussellHayes
Created July 9, 2014 12:59
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save AndrewRussellHayes/c48816b8f1b4fbb30a75 to your computer and use it in GitHub Desktop.
Save AndrewRussellHayes/c48816b8f1b4fbb30a75 to your computer and use it in GitHub Desktop.
pl/sql function template
/*
AUTHOR:Joe Developer
ACCEPTS:These Args
DOES:Performs Function
RETURNS:Return Value
DEPENDENCIES:Uses/Needs
NOTES: Special Considerations
*/
CREATE OR REPLACE FUNCTION FunctionTemplate(
parameter1 number,
parameter2 varchar2
)
RETURN number
IS --declaration_section
returnValue number;
--PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN --executable_section
return returnValue;
EXCEPTION --exception_section
when others
then return -1;
END FunctionTemplate;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment