Archives of the TeradataForum

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

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

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

Thanks

FM

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

They:

- 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>		<<First	<Prev	Next>	Last>>