Stored Procedure:
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:
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.