Return
-
Title
Cannot see the XML datatype column in Schema Browser | Data Tab -
Description
Cannot see the XML datatype column in Schema Browser | Data Tab. The whole column and header is missing or is not displayed. If I query the same table in SQL Editor, I am able to see the XML data type column.
-
Cause
Oracle Client software Oracle Data Access Components (ODAC) or Oracle Database On-line Analytical Processing (OLAP) is not fully supported in Toad for Oracle.
-
Resolution
Use the standard Oracle Database 11g Release 1 Client OR Oracle Database 10g Client Release 2. See the Oracle downloads link below.
http://www.oracle.com/technology/software/products/database/index.html
Alternatively, use the Oracle Instant Client 11g that is installed with an Oracle Client (ODAC) although this is also not fully supported in Toad for Oracle.