- I have XML strings stored as CLOB. When I ran a query to retrieve it, the Toad 10.6.1 Data Grid shows “(HUGECLOB).” In Toad 18.104.22.168, it use to show the actual value.
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 Browser
NOTE: Also verify that View Menu | Toad Options | Schema Browser | Data Tab | “Don’t select BLOB/CLOB fields” check box is NOT checked.