The differenced between procedures and functions

• Both take arguments which can be of any mode.
• Both are different forms of PL/SQL blocks, with a declarative, executable, and exception section.
• Both can be stored in the database or declared within a block.
• Both can be called using positional or named notation.
• Procedure call is a PL/SQL statement by itself, while a function call is called as part of any expression.
• A function call is an rvalue.
• If there is more than one returns value, use a procedure, if there is only one return value, a function can be used.