- Stored procedures enable a user to split the application logic between the client and server
- This technique is used to prevent the client applications from manipulating the contents of the server data
- Stored procedures are secured through encoding in the database and require admin privileges to execute the program
- Stored procedures perform input validation of data by verifying text, characters and numeric data
- Stored procedures prevent SQL injection attacks by performing thorough validation on any user input before processing the data
- Stored procedures use a safe interface such as a callable statement in JDBC (Java Database Connectivity)
- Stored Procedures also manage network traffic where a single SQL statement can be used to send and receive a series of SQL statements
04.Secure Coding Practices for Input Validation, EC-Council CASE JAVA