Forums Register Login

Difference between Stored Procedures and Functions

+Pie Number of slices to send: Send
Hi,

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

Regards,
Vineela
+Pie Number of slices to send: Send
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.
+Pie Number of slices to send: Send
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.
+Pie Number of slices to send: Send
Hi,
Thanks for ur replies.Can u please tell me in detail when should we optfor functions and when for stored procedures?

Regards,
Vineela
+Pie Number of slices to send: Send
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.
+Pie Number of slices to send: Send
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
You guys wanna see my fabulous new place? Or do you wanna look at this tiny ad?
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 1467 times.
Similar Threads
core
Doubt in math.round
Difference between getParameter and getAttribute
getAttribute vs getParameter
Network question: switch and router
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 12:47:25.