procedure vs function

[AdusumalliGopikumar]

Hello,

We can return the value by using a procedure using out parameter then what is the use to go for functions in pl/sql?

[gintsp]

One cannot use procedures in DML statements, however user defined functions can be used.
However usually user defined function usage makes the statements slower and therefore one should understand why he/she really uses them.

Gints Plivna

[debasisdas]

Hello,

We can return the value by using a procedure using out parameter then what is the use to go for functions in pl/sql?

Procedures are not designed to return values ,though you can do that by using OUT parameter.To return value u should use functions and to implement some other logic use Procedure.

[amitpatel66]

How ever you cannot call a function in SELECT statement if its return type is BOOLEAN.