- A Stored Procedure is always used to perform a specific task.
- It can return zero, one or more value.
- It can have both input and output parameters.
- Exception handling can be done using a try-catch block.
- A function can be called from a Procedure.
- Functions must return a single value.
- It can only have the input parameter.
- Exception handling cannot be done using a try-catch block.
- A Stored procedure cannot be called from a function.