Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

MES Stateless API

TABLE OF CONTENTS

ClearSpParameterCache(String) Method

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
The ClearSpParameterCache(string) method clears the parameter cache in the MES middleware for the specified stored procedure (SP). For performance reasons, the middleware caches the parameter list of an SP the first time the SP is called. If a custom SP's parameter list is subsequently changed, the middleware might not correctly call the SP until the cache is cleared.

Syntax

'Declaration
 
Public Overloads Shared Sub ClearSpParameterCache( _
   ByVal spName As String _
) 
'Usage
 
Dim spName As String
 
DirectAccess.ClearSpParameterCache(spName)
public static void ClearSpParameterCache( 
   string spName
)

Parameters

spName
Required. Holds the name of the SP to be cleared.

Remarks

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 performed 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.

See Also

Reference

DirectAccess Class
DirectAccess Members
Overload List

In This Topic
TitleResults for “How to create a CRG?”Also Available in