DynamicLoadErrorMode
This attribute controls what happens when an application executes a SQL operation against a dynamic cache group and the SQL operation cannot use dynamic load.
With a value of 0, the SQL operation executes against whatever data is in the TimesTen tables and returns a result based on that data with no error indicated.
With a value of 1, any statement that cannot use dynamic load (even if it does not need dynamic load) fails with an error indicating that it is not dynamic load-compliant.
For more information on caching data from an Oracle database in a TimesTen cache group, see Dynamic Cache Groups in Oracle TimesTen In-Memory Database Cache Guide.
Note:
To override the value of this attribute at the statement level, set the DynamicLoadErrorMode optimizer flag with the ttOptSetFlag built-in procedure or using the statement level optimizer hint TT_DynamicLoadErrorMode in a SQL statement.
For details, see Statement Level Optimizer Hints in Oracle TimesTen In-Memory Database SQL Reference.
Required Privilege
No privilege is required to change the value of this attribute.
Setting
Set DynamicLoadErrorMode as follows:
| Where to set the attribute | How the attribute is represented | Setting |
|---|---|---|
|
C or Java programs or UNIX and Linux systems |
|
|
|
Windows ODBC Data Source Administrator |
Not applicable |