Functions vs Stored Procedures
390534Sep 23 2003 — edited Nov 24 2011I 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