Unable to view Timestamp datatype columns in TOAD

[oracle_new]

Hi, I am using Toad to connect to oracle database server. When i do F4 to see the columns and data, it doesn't show the timestamp datatype's columns even though i can see the column name in columns. any idea about this? Is this a Toad issue or database issue?

next when i try to "create insert for all rows" toad just hangs! has anyone faced this before?

[Sadik]

are u able to see the timestamp column with SQL Plus? if yes then there's nothing wrong with oracle.. and it's probably some limitation with Toad. By the way which Toad version are you using?

[oracle_new]

i checked out with sql plus and it displays the timestamp column just fine, so it's probably TOAD. i am using toad 9.1 version

[tyro]

ohh i have seen this one before. Timestamp and even interval data types are not displayed with Toad if you are using an older oracle client version on your PC while connecting with Toad.

Install oracle 10g client and connect to Toad with 10g Home and your timestamp datatype will show up just fine.

[rajavu]

Even 9i Client version will do the same I guess or rather any version greater than or equal to 8i.

[oracle_new]

Hi Guys.. thank u so much! I installed Oracle 10g client and used the 10g client ORACLE_HOME and toad can now see the timestamp columns just fine