Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
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
You can’t perform that action at this time.