1:- Better Performance –
The process calls are quick and efficient because stored procedures are compiled once and stored in executable form. The response is quick. The executable code is automatically cached, therefore reducing memory requirements.
2:- Higher Productivity –
Since the same piece of code is used repeatedly, this results in higher productivity
3:- Ease of use -
To create a stored procedure, one can use the Java Integrated Development Environment. Then, they can be deployed at any level of network architecture.
4:- Scalability-
Stored procedures increase scalability by isolating the application process on the server.
5:-Maintainability –
It is very easy to maintain a process on a server then maintain copies on different client machines, this is because the scripts are in one place.
