Using Static Scrollable Cursors
- Last Updated: May 12, 2026
- 1 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
- The ODBC driver supports static cursors for all types of result set generating statements, including result sets generated by stored procedures.
- The ODBC driver supports LOB data for static cursors; however, by default, only the first 4096 bytes of the LOB column is buffered. See SLKStaticCursorLongColBuffLen for more information about specifying the amount of data that is buffered.
- To persist a result set as an XML data file with embedded schema, you must use static cursors. See Sending Arrays of Parameters for more information about persisting XML data files.