difference between stored procedure and function?

Question Posted / sekhar

4 Answers
9107 Views
Syntel, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

difference between stored procedure and function?..

Answer / m m naidu

A Procedure is a sub-program that performs a specific
action.

A Procedure can be called from PL/SQL Block or from another
Procedure also.

A function is very similar to a Procedure. Both take
arguments, which can be of different modes. Both are
different forms of PL/SQL blocks. Both can be stored in the
database.
A procedure call is a PL/SQL statement by itself, while a
Function call is called as part of an expression. And a
Function must return

Is This Answer Correct ?

7 Yes

0 No

difference between stored procedure and function?..

Answer / vsandhyana

Function can call anywhere in your select query but store
procedure cannot call from the select statement.

store procedure may or may not return values but function
should return value.

Thanks,
Vsandhyana

Is This Answer Correct ?

3 Yes

1 No

difference between stored procedure and function?..

Answer / arkchowdary

PL/SQL------------- It is a named PL/SQL Block.
------------- Which can take 1 or more values.
------------- It accepts Parameters.

Usage-------------- Reusability.
-------------- Precompatibility.

Whereas

Functions----------- It is a named PL/SQL Block.
----------- Which can take 1 or more values.
----------- It must a Returns value by using
return statement.

Is This Answer Correct ?

2 Yes

1 No

difference between stored procedure and function?..

Answer / ravi v

Function returns only 1 value, where as stored procedure
returns mutiple values.

Is This Answer Correct ?

1 Yes

2 No

Post New Answer