Description
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.
Applies to
ADO.NET
OLE DB
O90 Oracle9i
O10 Oracle 10g
ORA Oracle (for 11g and later)
SNC SQL Native Client for Microsoft SQL Server
MSOLEDBSQL Microsoft OLE DB Driver for SQL Server
Syntax
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. |
Default value
SPCache=50 (ADO.NET), SPCache=100 (others)
Usage
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.
Examples
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"
See also
