LOB Support
- Last Updated: May 12, 2026
- 2 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
The following example uses CLOB data; however, this procedure also applies to BLOB data. This example illustrates only one of several ways in which LOB data can be processed.
-
From the Connection window menu, select Connection / Create Statement.
-
Select Statement / Execute Stmt Query.
-
Specify the Select statement that you want to execute.
Click Submit; then, click Close.
-
Select Results / Inspect Results. The Inspect Result Set window is displayed.
-
Click Next. Current Row changes to 1.
-
Clear the Auto Traverse check box. This disables automatic traversal to the next row.
-
Click Get Cell.
-
Values are returned in the Get Cell Value field.
-
Change the Data Type to Clob.
-
Click Get Cell. The Clob data window appears.
-
Click Get Cell. The Cell Value field is updated with the Clob data.
