Basic difference b/w Function and Procedure

1.Function must return a value but stored procedure it is optional.

(procedure can return 0 or n values)

 

2. Function can have only input parameter, procedure can have input/output parameter.

 

3. Function take one input parameter it is mandatory   but stored procedure may take 0 to n input parameter.

 

4. Function can be called from procedure where as procedure can not be called from function.