Stored procedures

Executing stored procedures with different database engine types.

Stored procedures execution needs to be addressed specifically depending on the database type. There are different ways to execute a stored procedure. This section describes how to execute stored procedures on the supported database engines.


In order to write reusable code, it is recommended that you encapsulate each stored procedure execution in a FUNCTION performing database-specific SQL based on a global database type variable. The program function would just take the input parameters and return the output parameters of the stored procedure, hiding database-specific execution steps from the caller.