1->stored procedure can not be written as a column name but 
function can be written as a column name
2->result set of stored procedure can not be used in 
joining tables but table return by function can be used in 
joins

1>Stored procedure is pre-executed block of code whereas
function is not.
2>Stored procedure may return zero,one or more than one value
whereas function always return one and only one value..
3>We can use try catch block in stored procedure whereas
function doesn't support try catch block...
4>We can't use stored procedure in select statement whereas we 
use function in select statement..

SP may return value or may not ,function always treturn 
value. 
SP cannot use in sselect statment or in sql stattment ,We 
can use Function in any where in sql statment. 
Packeage is set of statment,SP,Function Which run one by 
one statment in that.

We cannot write DML in Function whereas in SPs we can

In general SPs are sequential block of PL/SQL for 
Transaction
Func are used for specific calculation / selection