A stored procedure is named collection of SQL statements and procedural logic that is compiled, verified and stored in a server DATABASE. It is TYPICALLY treated like any other database object. Stored procedures ACCEPT input parameters so that a single procedure can be used over the network by MULTIPLE clients using different input data. A single remote message triggers the execution of a collection of stored SQL statements. The results is a reduction of network TRAFFIC and better performance.

A stored procedure is named collection of SQL statements and procedural logic that is compiled, verified and stored in a server database. It is typically treated like any other database object. Stored procedures accept input parameters so that a single procedure can be used over the network by multiple clients using different input data. A single remote message triggers the execution of a collection of stored SQL statements. The results is a reduction of network traffic and better performance.