Below are the main differences between stored procedure and functions-
1.Function has a return type but Stored procedure doesn't have a return type.
2.Stored Procedure supports IN/OUT/IN-OUT Parameters while function supports only IN parameters.
3.Stored procedure can contain all the DML(Select,update,insert,delete) statements but function can contain only select statement.
4.Function can be called from a stored procedure but stored procedure cannot be executed from a function.
5.For Exception Handling, the stored procedure can contain try---catch block but Function doesn't support try---catch block.