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.

Tip: 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.