What are the disadvantages of using the stored procedures?

devquora
devquora

Posted On: Feb 22, 2018

 

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.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Stored procedures Interview questions

    What do you understand by a stored procedure?

    The group of SQL statements which are or have been stored in the server database is known as a stored procedure. Input ..

    Stored procedures Interview questions

    Mention the uses of stored procedures.

    Stored procedures are used for various different things. Some of the uses of stored procedures are as follows:Stored p..

    Stored procedures Interview questions

    What are the types of stored procedures in an SQL server?

    The types of stored procedures present in an SQL server are listed as follows: – User-defined stored procedures– th..