Note: LOB support (Blobs and Clobs) requires a Java SE 1.4 or higher JVM.
The following example uses Clob data; however, this procedure also applies to Blob data. This example illustrates only one of multiple ways in which LOB data can be processed.
1. From the Connection window menu, select Connection / Create Statement.
2. Select Statement / Execute Stmt Query.
3. Specify the Select statement that you want to execute.
4. Click Submit; then, click Close.
5. Select Results / Inspect Results. The Inspect Result Set window appears.
6. Click Next. Current Row changes to 1.
7. Deselect Auto Traverse. This disables automatic traversal to the next row.
8. Click Get Cell. Values are returned in the Get Cell Value field.
9. Change the data type to Clob.
10. Click Get Cell. The Clob data window appears.
11. Click Get Cell. Values are returned in the Cell Value field.
