Action is a part of Function.
Function is a Like a Functional Test case.
Procedure is a process to perform the Different Actions

function can return a value
procedure cannot return a value,

1.Function returns a value, but a procedure may return or
may not return a value.
2.Function can take only input aurguments, but procedure may
take both input and out put parameters.

All are correct....

Fuction returns a value whereas procedure doesnt return any
value 
if some function calling is dere den function switch over 2
d function definition part directly but procedure go from
top 2 down linearly

function can be called inside the select statement but not 
the procedure

Bot functions and procedures can return values. Apart from
this following are the differences

1) Functions are used for computations where as procedures
can be used for performing business logic

2) Functions MUST return a value, procedures need not be.

3) You can have DML(insert,update, delete) statements in a
function. But, you cannot call such a function in a SQL query..
eg: suppose, if u have a function that is updating a table..
you can't call that function in any sql query.
- select myFunction(field) from sometable; will throw error.

4) Function parameters are always IN, no OUT is possible

5) Function returns 1 value only. procedure can return
multiple values(max. 1024)

6) Stored Procedure :supports deffered name resoultion
Example while writing a stored procedure that uses table
named tabl1 and tabl2 etc..but actually not exists in
database is allowed only in during creation but runtime
throws error Function wont support deffered name resolution.
Stored procedure returns always integer value by default
zero. where as function return type could be
scalar or table or table values(SQL Server).
  Stored procedure is pre compiled exuction plan where as
functions are not.

7) A procedure may modifiy an object where a function can
only return a value.

Function means Lot of people gathering together and 
celeberate somthing.
Example:Birth day function,Marriage function
Procedure not somthing like that.

Function must returs a value, but procedure can return more 
and not any value..

Fuction are used for check conditions, but procedures can 
be use check condition as well as for the bussiness logic.

1.Funcan can return a valur but not procedure
2.Function can accept only one parameter IN but procedure 
can take IN or OUT or both parameters.
3.Procedure follows only linear execution but not function.

Question:	Difference Between 	Procedure & 
Function?
1). Both functions and procedures can return values.

2). Both can return multiple values, like in the case of 
procedure it can return multiple values using OUT and INOUT 
type parameter, while in case of function used in Report 6i,
using "PLACEHOLDER COLUMN" you can return multiple values.

3). "Complete Reference" Book say that function can use 
parameters as IN, OUT, and INOUT as same as in Procedure.

/* 

create function syntax

The syntax for the create function command is more 
complicated than the syntax for the create procedure
command. At a high level, the syntax is

create [or replace] function [schema.] function
	[(argument [in | out | inout ] [nocopy] datatype
		[, argument [in | out | inout ] [nocopy] 
datatype]...
	)]
return datatype

*/

4). Function returns value using "Return" Key Word, where 
same key word can be used in Procedure to Terminate the 
program, with immidiate effect.

5). Functions are used for computations where as procedures
can be used for performing business logic.

6). Functions MUST Return a value, procedures need not be.

7). You can have DML(insert,update, delete) statements in a
function. 

8). You can call a function in a Select Query where as
not Procedure.

9). Function returns 1 value only where as Procedure can 
return
multiple values(max. 1024)

10). A procedure may modifiy an object where a function can
only return a value.

1.Function always return a single value but procedure may 
return more than one value.
2.We can use functions in select statement but we can not 
use procedure in select statement.
3.There is possible of recurssive functionlike max(min
(something)),but there is nothing like in procedure.
4.In function we use a return keyword but in procedure no 
return keyword is used.

1.Function is mainly used in the case where it must return 
a value. Where as a procedure may or may not return a value 
or may return more than one value using the OUT parameter.
2.Function can be called from sql statements where as 
procedure cannot be called from the sql statements.
3.Functions are normally used for computations where as 
procedures are normally used for executing business logic. 
4.You can have DML (insert, update, delete) statements in a 
function. But, you cannot call such a function in a SQL 
Query.
5.A Function returns 1 value only. Procedure can return 
multiple values (max 1024). 
6.Stored Procedure: supports deferred name resolution. 
Example while writing a stored procedure that uses table 
named tabl1 and tabl2 etc...But actually not exists in 
database is allowed only in during creation but runtime 
throws error Function won’t support deferred name 
resolution. 
7.Stored procedure returns always integer value by default 
zero. whereas function return type could be scalar or table 
or table values
8.Stored procedure is precompiled execution plan where as 
functions are not.
9.A procedure may modify an object where a function can 
only return a value The RETURN statement immediately 
completes the execution of a subprogram and returns control 
to the caller.

1. Function can return only one value but procedure can return more than one, or may not return any value.

2. Function can be called from sql statements where as procedure cannot be called from the sql statements.

3. We can use functions in select statement but we can not use procedure in select statement.

Function and procedure hv got their own use.

The following are the difference between function and 
procedure..

1. Function can used with select/where clause , while 
procedure can't
2.we can call a function from a procedure ,but it is not 
possible to call a procedure from a function