Functions are named PL/SQL blocks that return a value and can be called with arguments procedure a named block that can be called with parameter. A procedure all is a PL/SQL statement by itself, while a Function call is called as part of an expression.

usha`

• Aug 19th, 2011

Functions can be used in a select statement where as procedures cannot.

functions cannot return values where as procedures can.

functions can be used as user defines data types in create table but procedures cannot.

Prakash Jayabalan

 Profile Answers by Prakash Jayabalan Questions by Prakash Jayabalan

• Oct 29th, 2009

Procedure:Parameters IN, OUT and IN OUT and can return n number of values via sys cursor.Function:Only IN parameter and must return a value by using RETURN.Can be used in where clause of the Query but performance issue will raise.

Answer Question  Select Best Answer