Choosing a Stored Procedure Type

Refer to these suggestions to determine the procedure type you need:

• Use a subroutine when you need to return the values of the arguments passed to the subroutine.
• Use a function when you need to pass arguments and return a single value when the function is complete.