Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 24 Nov 2010 @ 14:57:18 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Pros and Cons of Stored Procedures
From:   Faible Mou


We all know the benefits of Stored Procedures as follows. But what else should I consider when choosing to use them?



PS. Applications based on stored procedures provide the following benefits.


- Reduce network traffic in the client-server environment because stored procedures reside and execute on the server.

- Allow encapsulation and enforcement of business rules on the server, contributing to improved application maintenance.

- Provide better transaction control.

- Provide better security. The data access clause of a stored procedure can restrict access to the database.

- Provide better security by granting the user access to the procedures rather than to the data tables.

- Provide an exception handling mechanism to handle the runtime conditions generated by the application.

- Allow all the SQL and SQL control statements embedded in a stored procedure to be executed by submitting one CALL statement. Nested CALL statements further extend the versatility.

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023