This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |
| ref:a_f:a:exec_sp [2026/08/13 00:43] – ↷ Page moved from a_f:a:exec_sp to ref:a_f:a:exec_sp localdev | ref:a_f:a:exec_sp [2026/08/13 00:55] (current) – ↷ Links adapted because of a move operation localdev |
|---|
| |
| * ''SPName'' is the name of the stored procedure to execute (must be enclosed in apostrophe) | * ''SPName'' is the name of the stored procedure to execute (must be enclosed in apostrophe) |
| * ''DatabaseEnvironment'' if present indicates the name of the database environment where the stored procedure is defined (see objects persisted in [[docs:2500_config_apps:2300_external_sys_ldap|external databases]]). If not present the native AwareIM database is used. | * ''DatabaseEnvironment'' if present indicates the name of the database environment where the stored procedure is defined (see objects persisted in [[2500_config_apps:2300_external_sys_ldap|external databases]]). If not present the native AwareIM database is used. |
| * ''ParamName'' is the name of the parameter of the stored procedure (if stored procedure requires a parameter. A parameter can be ''IN'', ''OUT'' or ''INOUT''. If parameter type is omitted ''IN'' is assumed | * ''ParamName'' is the name of the parameter of the stored procedure (if stored procedure requires a parameter. A parameter can be ''IN'', ''OUT'' or ''INOUT''. If parameter type is omitted ''IN'' is assumed |
| * ArithmeticExpression an AwareIM expression to initialize input parameters with. If the parameter is of ''OUT'' or ''INOUT'' type this expression must be the name of an attribute of a business object | * ArithmeticExpression an AwareIM expression to initialize input parameters with. If the parameter is of ''OUT'' or ''INOUT'' type this expression must be the name of an attribute of a business object |
| <code aim>EXEC_SP 'proc1' OF SQLServer WITH '@param1'=1,'@param2'=2 RETURN SomeObject </code> | <code aim>EXEC_SP 'proc1' OF SQLServer WITH '@param1'=1,'@param2'=2 RETURN SomeObject </code> |
| |
| This stored procedure returns the specified records from an [[docs:2500_config_apps:2300_external_sys_ldap:0100_define_objects_using_exist_table|external database]] identified by the name SQLServer. | This stored procedure returns the specified records from an [[2500_config_apps:2300_external_sys_ldap:0100_define_objects_using_exist_table|external database]] identified by the name SQLServer. |
| |
| |
| |