Package com.saperion.operations
Class ExecuteStoredProcedure
java.lang.Object
com.lexmark.saperion.remote.common.operations.AbstractOperation<T,SaBasicException,LegacyConnection>
com.saperion.operations.LegacyOperation<com.lexmark.saperion.remote.common.operations.Void>
com.saperion.operations.VoidOperation
com.saperion.operations.ExecuteStoredProcedure
- All Implemented Interfaces:
com.lexmark.saperion.remote.common.operations.Operation<com.lexmark.saperion.remote.common.operations.Void,
,SaBasicException, LegacyConnection> Serializable
Executes a stored procedure on the database. Allows neither return value nor var parameters. Input parameters
are allowed and are mapped as follows:
long | INT |
integer | INT |
short | INT |
byte | INT |
double | FLOAT |
float | FLOAT |
String | NVARCHAR |
boolean | INT - 1 for true, 0 for false |
Date | DATETIME2 |
Calendar | DATETIME2 |
- See Also:
-
Constructor Summary
ConstructorsConstructorDescriptionExecuteStoredProcedure
(String name, String dataSource, Serializable... parameters) Creates a new instance of ExecuteStoredProcedure that executes the given stored procedure on the database given by the data-source with the given parameters.ExecuteStoredProcedure
(String name, String dataSource, List<Serializable> parameters) Creates a new instance of ExecuteStoredProcedure that executes the given stored procedure on the database given by the data-source with the given parameters. -
Method Summary
Methods inherited from class com.saperion.operations.VoidOperation
afterInvoke, getResult, invoke
Methods inherited from class com.saperion.operations.LegacyOperation
beforeInvoke, beforeInvoke, getClientToken, mapEcmException, mapException
Methods inherited from class com.lexmark.saperion.remote.common.operations.AbstractOperation
toArrayList, toCaseInsensitiveMap, toHashMap
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
Methods inherited from interface com.lexmark.saperion.remote.common.operations.Operation
audit, dispatchEvent, isAuditable, isEventDispatcher
-
Constructor Details
-
ExecuteStoredProcedure
Creates a new instance of ExecuteStoredProcedure that executes the given stored procedure on the database given by the data-source with the given parameters.- Parameters:
name
- The name of the procedure to executedataSource
- The name of the data-source on whose database the procedure will be executedparameters
- The parameters given to the stored procedure. For type-mapping seeExecuteStoredProcedure
-
ExecuteStoredProcedure
Creates a new instance of ExecuteStoredProcedure that executes the given stored procedure on the database given by the data-source with the given parameters.- Parameters:
name
- The name of the procedure to executedataSource
- The name of the data-source on whose database the procedure will be executedparameters
- The parameters given to the stored procedure. For type-mapping seeExecuteStoredProcedure
-
-
Method Details
-
voidInvoke
Description copied from class:VoidOperation
Invokes this void operation.- Specified by:
voidInvoke
in classVoidOperation
- Throws:
Exception
- exception when invoking this operation
-
toString
- Overrides:
toString
in classcom.lexmark.saperion.remote.common.operations.AbstractOperation<com.lexmark.saperion.remote.common.operations.Void,
SaBasicException, LegacyConnection>
-