-
タイトル
Missing columns when querying, after installing Oracle Data Access Components (ODAC) 11g (11.1.0. -
説明
Installed Oracle Data Access Components (ODAC) 11g (11.1.0.621). When using this 11g Oracle Home to connect, certain datatypes are not displaying in a query. e.g.
When reviewing data in the Schema Browser data grid for a table which contains a timestamp, the whole column is missing from the data grid including the column header.
-
原因
ODAC includes an 11g Instant Client, which is currently not supported. (see SOL45523 for current status of 11g Instant Client support). If Toad does not recognise the client version, the following datatypes will not be displayed:
BLOB, CLOB, NCLOB, XMLTYPE, TIMESTAMP, INTERVAL, BINARY_DOUBLE, BINARY_FLOAT
-
対策
SOLUTION 1:
Copy 'oci.dll' and 'oraociei11.dll' from the <oracle client directory> to the <oracle client directory\bin\
e.g.
Copy the two files from ' C:\app\wkr\product\11.1.0\client_1' to the ' C:\app\wkr\product\11.1.0\client_1\bin'Also ensure that 'C:\app\wkr\product\11.1.0\client_1\bin' is the first entry in the PATH environment variable.
Solution 2:
Install a full Oracle 11g client