Return
-
Title
How to view XML data stored as CLOB when it is displayed as (HUGECLOB) in Data Grid. -
Description
I have XML strings stored as CLOB. When I ran a query to retrieve it, the Toad 10.6.1 or above Data Grid shows "(HUGECLOB)." In Toad 9.7.2.5, it use to show the actual value.
-
Resolution
1. Go to View | Toad Options
2. Expand Data Grids | Data
3. On the right-hand side, check 'Preview CLOB and LONG data'
4. Click on OK and refresh your Schema BrowserNOTE: Also verify that View Menu | Toad Options | Schema Browser | Data Tab | "Don't select BLOB/CLOB fields" check box is NOT checked.