This chapter describes how stored procedures can be used for database manager applications running in a client/server environment.
This technique allows an application running on a client to call a procedure stored on a database server. This stored procedure executes and accesses the database locally and returns information to the client application.
To use this technique, an application must be written in two separate procedures. The calling procedure is contained in a client application and executes on the client. The stored procedure executes at the location of the database on the database server.
The following topics are discussed: