What are the disadvantages of using the stored procedures?

Everything which has advantages has disadvantages too. The disadvantages of using stored procedures are listed below:

• Specialized skills are required for writing and maintaining the code of a stored procedure.
• Debuggers are not available for a stored procedure.
• The language in which a stored procedure is written may differ from one database to the other.
• Exception handling in a stored procedure is not up to the mark.
• These are tightly coupled to the database.
• You may not be able to use objects.
• Sometimes the logic may not be understood by the programmers.