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.
both the procedure and functon accept more than one variable.Function do not have an out variable where as procedures return variable to the calling environment using out variables not the return cluase where as function return value using return clause.and it must return a value but procedure may or maynot.
1) Function may return a value whereas procedure may or may not return value. 2) Function cannot accept parameter but procedure accept parameter. 3) We can call function in a select statement with clauses but procedure doesn't. 4) We cannot use INSERT,UPDATE,DELETE in function. 5) Procedure is used as a statement in a PL/SQL block whereas Function is used as a expression in a PL/SQL block.