Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 7 2013
Added on May 10 2013
11 comments
5,120 views