Stored Procedure

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

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. 

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..

hi dipak,

agree with vulpes, just want to add
it diffucult to handle versionof SP.
And Difficult to debug.


hope this help.