LOB Support

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.

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.

   

   Click Submit; then, click Close.

4. Select Results / Inspect Results. The Inspect Result Set window is displayed.

5. Click Next. Current Row changes to 1.

   

6. Clear the Auto Traverse check box. This disables automatic traversal to the next row.

7. Click Get Cell.

   

8. 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. The Cell Value field is updated with the Clob data.