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

public class ExecuteStoredProcedure extends VoidOperation
Executes a stored procedure on the database. Allows neither return value nor var parameters. Input parameters are allowed and are mapped as follows:
longINT
integerINT
shortINT
byteINT
doubleFLOAT
floatFLOAT
StringNVARCHAR
booleanINT - 1 for true, 0 for false
DateDATETIME2
CalendarDATETIME2
See Also:
  • Constructor Details

    • ExecuteStoredProcedure

      public 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.
      Parameters:
      name - The name of the procedure to execute
      dataSource - The name of the data-source on whose database the procedure will be executed
      parameters - The parameters given to the stored procedure. For type-mapping see ExecuteStoredProcedure
    • ExecuteStoredProcedure

      public ExecuteStoredProcedure(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.
      Parameters:
      name - The name of the procedure to execute
      dataSource - The name of the data-source on whose database the procedure will be executed
      parameters - The parameters given to the stored procedure. For type-mapping see ExecuteStoredProcedure
  • Method Details

    • voidInvoke

      protected void voidInvoke() throws Exception
      Description copied from class: VoidOperation
      Invokes this void operation.
      Specified by:
      voidInvoke in class VoidOperation
      Throws:
      Exception - exception when invoking this operation
    • toString

      public String toString()
      Overrides:
      toString in class com.lexmark.saperion.remote.common.operations.AbstractOperation<com.lexmark.saperion.remote.common.operations.Void,SaBasicException,LegacyConnection>