SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Difference between function and procedure

996283May 10 2013 — edited May 10 2013

Hi All,

My doubt is that procedure can be used to return multiple values with OUT parameter and function can also be used to do the same if needed to return multiple values with OUT parameter.

So with this point of view what may be the difference between these two object types. and obviously if required to choose one from these two, we will go for procedure, why not function?

what may be the reason for it?

Thanks in advance.

Regards,
Vipin Kumar Rai

This post has been answered by BluShadow on May 10 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 7 2013

Added on May 10 2013

11 comments

5,237 views