skip to main content
Part 2: The 32-Bit/64-Bit Drivers : The Oracle Wire Protocol Driver : Connection Option Descriptions : Enable Static Cursors for Long Data
  
Enable Static Cursors for Long Data
Attribute
EnableStaticCursorsForLongData (ESCLD)
Purpose
Determines whether the driver supports Long columns when using a static cursor. Enabling this option causes a performance penalty at the time of execution when reading Long data.
Valid Values
0 | 1
Behavior
If set to 1 (Enabled), the driver supports Long columns when using a static cursor.
If set to 0 (Disabled), the driver does not support Long columns when using a static cursor.
Notes
*You must enable this option if you want to persist a result set that contains Long data into an XML data file.
*This connection option can affect performance.
Default
0 (Disabled)
GUI Tab
Performance tab
See also
Performance Considerations