A StoredProcedure service calls a stored procedure to perform database operations. The SQL statement for an adapter service can also be a stored procedure call. A stored procedure is SQL code that is encapsulated in a statement and compiled into executable code. It is an object that is stored in the database and called when the adapter applies the SQL statement to the database.

Stored procedures provide greater flexibility in performing database operations in response to documents. You can configure operations for stored procedure calls with or without parameters. To learn how to create a stored procedure, see the vendor documentation for your database.