Skip to Main Content

Oracle Database Discussions

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!

Functions vs Stored Procedures

390534Sep 23 2003 — edited Nov 24 2011
I have a dumb question for all the Oracle Experts....

What is the difference between using Stored Procedures and Functions in Oracle 9i (all Oracle for that matter I guess).

They both can return values, they both take parameters... Is there any difference?

I know in the app dev world functions can be overloaded in an inheritance structure but not sure about the dif in a DB world?????

What are Pros and Cons of each?

Just curious,
Miller
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 22 2011
Added on Sep 23 2003
15 comments
106,423 views