Stored Procedure

Question

Hi I want to know that Is any kind of disadvantages using the so much stored procedures ?

Jignesh Trivedi · Answer

hi dipak agree with vulpes just want to add it diffucult to handle versionof SP. And Difficult to debug. hope this help.

Dipal Choksi · Answer

Here is are articles detailing the disadvantages of SPs - http://www.spoiledtechie.com/post/Whats-up-with-Stored-Procedures-these-days.aspx http://weblogs.asp.net/fbouma/archive/2003/11/18/38178.aspx Here is another good discussion .This has links to additional resources/information too..

Vulpes · Answer

The only disadvantage of stored procedures that I can think of is lack of portablility. In other words an SP written for one RDBMS may not work with another. This may be because of differences in the SQL dialects used or because one RDBMS supports features which another one does not.