This week's book giveaway is in the Artificial Intelligence and Machine Learning forum.
We're giving away four copies of TensorFlow 2.0 in Action and have Thushan Ganegedara on-line!
See this thread for details.
Win a copy of TensorFlow 2.0 in Action this week in the Artificial Intelligence and Machine Learning forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Paul Clapham
  • Bear Bibeault
  • Jeanne Boyarsky
Sheriffs:
  • Ron McLeod
  • Tim Cooke
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Jj Roberts
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • salvin francis
  • Scott Selikoff
  • fred rosenberger

Difference between Stored Procedures and Functions

 
Ranch Hand
Posts: 191
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

Can anyone pls explain me the diff between StoredProcedures and Functions?

Regards,
Vineela
 
Ranch Hand
Posts: 8943
Firefox Browser Spring Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Functions are supposed to be utility kind of code which return some value whereas procedures can have side effects i.e. it changes some value in the database. SP can have IN/OUT parameters which means that more than one return value is possible.
 
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
A Procedure may or may not return a value.By default it wont return any thing.You have to make it return some value by the use of OUT or IN/OUT parameter.

Function will return a value by default.
 
Vineela Devi
Ranch Hand
Posts: 191
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
Thanks for ur replies.Can u please tell me in detail when should we optfor functions and when for stored procedures?

Regards,
Vineela
 
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Totally depends on you, wanting sth returned or not.

Say in one case, I had to ignore any exception returned, and in case of any just would inform the end user by getting "-1" as return from a function.

Actually from the point of the database they (proc. and fnctn) are no different.
 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
Basically a stored proc can do everything that a function can but the opposite need not be true always.
Like you cannot change the system date etc from a UDF but you can do it from a Stored Proc.

--Nilesh
reply
    Bookmark Topic Watch Topic
  • New Topic