ClearSpParameterCache() Method
- Last UpdatedMar 17, 2026
- 1 minute read
'Declaration
Public Overloads Shared Sub ClearSpParameterCache()
'Usage
DirectAccess.ClearSpParameterCache()
public static void ClearSpParameterCache()
This method is useful when modifying custom stored procedures being called by the ExecSP() and GetDSbySP() methods. For example, a developer is modifying a custom stored procedure by adding a new parameter and is calling this stored procedure with the ExecSP() API method. To use the new parameter in the API call, the developer can either restart the MES middleware, call this API method to clear the parameter cache, or use the MES Clear Parameter Cache utility to clear the parameter cache. Once modifications to the custom stored procedure are complete, this API call should be removed from the production system.
When putting changes to SPs into production, the MES Clear Parameter Cache utility can be used to clear the cache for the middleware. This will need to be done on each middleware node to ensure that the changed SPs can be called from all clients. For information about clearing the middleware cache using this utility, see the topic "Clearing the Middleware Stored Procedure Parameter Cache" under "Using the Stateless API" in this help.