A Function returns a value to the caller where as a Procedure does not.

RPush

 Profile Answers by RPush Questions by RPush

• Aug 5th, 2010

Procedure executes as a part of PL/SQL block wherein Function invoked as part of expression.Function must have RETURN keyword in the header , which is not applicable for Procedure.Function must return...

sameer rokde

 Profile Answers by sameer rokde Questions by sameer rokde

• Aug 3rd, 2010

Procedure is to do specific task where as function is to compute values.Procedure may or may not return value at all, but function must return value.Function can be used in SQL statement but Procedure is not used.

Answer Question  Select Best Answer