Table of Contents

, , , , , ,

EXEC_SP

This action allows execution of a database stored procedure.

Syntax

EXEC_SP SPName [ OF DatabaseEnvironment ] [ WITH ParamName = ArithmeticExpression ()[ INOUT)|OUT ] ( , ParamName = ArithmeticExpression () [ INOUT ) | OUT ] )* ] [ RETURN ObjectName ]

where:

Examples

EXEC_SP 'procAlertGetAll' RETURN Alert 

This stored procedure does not require any parameters. It selects all alert records in the native database, that Aware IM will automatically convert to instances of the Alert object and put in the context or make available for a query

EXEC_SP 'procAlertGet' WITH '@alerID'=1 RETURN Alert 

This stored procedure returns alert record with id=1

EXEC_SP 'procAlertGet' WITH '@alerID'=SPParam.AlertId RETURN Alert 

This stored procedure returns alert record with id taken from the AlertId attribute of the SPParam object

EXEC_SP 'procAlertGetOut' WITH '@alerID'=SPParam.AlertId,'@alertName'=SPParam.AlertName OUT  

This stored procedure returns alert record with id taken from the AlertId attribute of the SPParam object. The name of the alert is then written into the AlertName attribute.

EXEC_SP 'proc1' OF SQLServer WITH '@param1'=1,'@param2'=2 RETURN SomeObject 

This stored procedure returns the specified records from an external database identified by the name SQLServer.