They also do not provide good protection. Hybrid database server architectures, in theory is very good. It is always good to check references before deciding on a particular type of architecture. Stored procedures are collections of SQL statements and flow control directives that are verified, compiled, bound and stored at the DBMS server. They allow for input parameters, output parameters, declared variables and conditional execution of any commands or statements.
Stored procedures enhance DBMS performance.
The corresponding instruction set may be measured in several thousand machine instructions. If it has to be performed every time an SQL statement is executed, the resulting performance will be greatly decreased. This is true in case of static SQL also, however, in a static mode SQL statements are parsed, verified, compiled, bound and stored in DBMS server before they are executed or the first time they are executed. Consecutive executions will be done at much smaller expense. They also reduce considerably network traffic by eliminating the need to send SQL statements from applications to DBMS servers.