Help with CLOB column in TPD Pro

Toad Data Point & Toad Intelligence Central
1

The Clob data is excluded when the following code is used in TDP Pro workbook.
(Oracle database with 32bit odbc)
SELECT SYSDATE sys_dt,
sa.plant,
sa.po_no,
sa.note_type,
impact.OAC_UTILS.LONG_TO_CLOB_SA_PON (po_no, note_type,
plant) note_Description
FROM SA_PURCHASE_ORDER_NOTES sa;

image
image599×391 20.3 KB

Do you have any recommendations on how to correct it?

2

Hi James,

By default, Toad Data Point excludes LOB columns from result sets unless you explicitly request them. To include them do the following:

  • Go to Tools → Options → Database → General and check the Read LOBs when initially fetching data option
  • Click the OK button to save the changes and rerun the query

image
image967×198 20.2 KB

If you prefer not to always show CLOBs inline (for performance reasons), you can:

  • Leave the Read LOBs when initially fetching data option unchecked,
  • But still double-click the CLOB cell in the grid to open the full text

More information about this topic you can find in this article How to work with SQL Server Text Data Type (CLOBs) in Toad Data Point