Archives of the TeradataForum
Message Posted: Wed, 24 Nov 2010 @ 14:57:18 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|