Both(functions and Procedures) are the Oracle Objects that work explicitly towards database objects like Tables,Views.
The diff. b/t Stored Procedures and Functions
1) The procedures doesn't return values. whereas the function returns value.
2) The procedures accept more than one argument whereas the functions not.
Diff between Function and Procedure 1)Procedure is used in PLSQL block as a statment whereas Function is used as expression in the PL/SQL block. 2)Function can be used in SQL (with some restriction) but procedure can't. 3)Procedure cann't returns any value but fuction has to return a value.