Specifies the number of stored procedures for which the driver caches information.
When to specify SPCache
If you want to change the default value for SPCache, you must
specify a new value before connecting to the
database. The value cannot be changed at runtime.
ADO.NET
OLE DB
O90 Oracle9i
O10 Oracle 10g
ORA Oracle 11g
SNC SQL Native Client for Microsoft SQL Server
SPCache=value
Parameter |
Description |
|---|---|
value |
A number that specifies how many stored procedures are added to a cache that contains information about each stored procedure’s parameters. To turn off caching, specify 0. |
SPCache=50 (ADO.NET), SPCache=100 (others)
By default, the driver retrieves information from the server about a stored procedure’s parameters the first time the stored procedure is called and caches that information. The next time the procedure is called, the driver retrieves the information from the cache to improve performance. The information is retrieved based on the stored procedure’s name. The name is case sensitive.
If you call two different stored procedures with the same name, you can turn off caching by setting the value of SPCache to 0.
To turn off caching of stored procedure parameter information:
Database profile Specify 0 in the Maximum Procedures to Cache box on the System page in the Database Profile Setup dialog box.
Application Type the following in code:
SQLCA.DBParm="SPCache=0"
