Which one is used to better performance

[krishhhna]

Hi,
I have a doubt on procedure and function's,that is nI have one procedure that returns one value and function which also returns only one value. which one is better to use ,either procedure or function??

[debasisdas]

Use a function if u must return a value. even though u can return value through procedure using out parameters ,it is not recommended.

[amitpatel66]

Hi,
I have a doubt on procedure and function's,that is nI have one procedure that returns one value and function which also returns only one value. which one is better to use ,either procedure or function??

Procedure can reutnr more than one value using multiple OUT parameters.
But making use of function is always advisable if it satisfies the requirement!!