Stored Procedure - Disadvantages


  • Stored procedure languages are quite often vendor-specific. Switching to another vendor's database most likely requires rewriting any existing stored procedures.
  • Stored procedure languages from different vendors have different levels of sophistication.
    • For example, Oracle's PL/SQL has more language features and built-in features (via packages such as DBMS_ and UTL_ and others) than Microsoft's T-SQL.
  • Tool support for writing and debugging stored procedures is often not as good as for other programming languages, but this differs between vendors and languages.
    • For example, both PL/SQL and T-SQL have dedicated IDEs and debuggers. PL/PgSQL can be debugged from various IDEs.

Read more about this topic:  Stored Procedure