Stored procedures offer flexibility to the user and help him automate a particular task. In addition, support for stored procedures is one of the major sources of incompatibility between databases.
For a user, it is important to know whether the RDBMS supports stored procedures and if it does then in which language, such as PL/SQL, Java, C, or C++.