Database

[Sri]

Hi erman,

I am beginer in oracle plsql.My actual domain is soa.

I wanted the diff between package,procedure and function,why we will use package instead of functions.i have searchef in internet but not satistied.

Thank you

[ErmanArslansOracleBlog]

There are lots of related articles and comments about this topic.

You need to read PLSQL tutorials, in the first place.

Basically, functions must return a value. However, retuning a value is not a must for procedures.
A stored procedure cannot be used in a select statement. The functions, however; can be used in a select statement .
Packages are collections of procedures, functions, types, and variables.