Data type is not supported

gymwalker · Post by **gymwalker** » Wed 09 May 2007 23:57

I just installed the ODAC and am getting a 'Data Type is not supported' error when I try to access a table in my Oracle Db from my Delphi 6 Application.

I'm guessing this is because of the VARCHAR2 data type in the Oracle DB...so how do I get around this problem without restructuring the DB?

Acually I found a post where it might be the TIMESTAMP data type...so if it is not supported...am I then unable to use the ODAC? Is there a way to configure Delphi 6 to handle this data type?

Thanks in advance!
Jim

Plash · Post by **Plash** » Thu 10 May 2007 09:06

ODAC supports the VARCHAR2 and TIMESTAMP data types. Please provide a script for creating the table which you are trying to open.
Also supply the following information:
- exact version of ODAC including build number (see Oracle | About ODAC in the IDE menu);
- whether you are using the Direct option to connect to the database.

gymwalker · Post by **gymwalker** » Thu 10 May 2007 17:29

The Table already exists so its not one I'm creating...here is what it looks like:

CHANGE_ID_$$ NUMBER(38,0)
SRC_SYS_TRANS_DT TIMESTAMP(6)
ORDER_NUMBER VARCHAR2(8 BYTE)
ORDINAL NUMBER(4,0)
CUSTOMIZE_SEQ_NUMBER NUMBER(4,0)
CUSTOMIZE_CODE VARCHAR2(20 BYTE)
CUSTOMIZE_DATA CHAR(60 BYTE)

I am using Oracle Data Access Components (Trail Version) 6.00.0.6 for Delphi 6.

I don't think I'm using the Direct option to connect to the database...I'm not sure how to do this...I was just trying to use the VCL Objects as they came.

I have a FORM...on that form I've placed a TOraSession, a TOraTable, a TDataSource and a TDBGrid.

This is a simple program to see if I can access the data in an Oracle DB.

I hope this helps you solve this issue for me! If there is anything else you need, please let me know.

Thanks a bunch!
Jim

Plash · Post by **Plash** » Fri 11 May 2007 07:17

We could not reproduce this problem. Please send to odac*crlab*com a complete small sample that demonstrates the problem, including script to create server objects.

MarkF · Post by **MarkF** » Fri 11 May 2007 11:38

Hi Jim,

Are you using at least the Oracle 9 client? If you use earlier clients with the timestamp datatype you'll get an error that (if I remember properly) sounds like that. Try a query with just a timestamp in it to see if that datatype is the problem.

-Mark

gymwalker · Post by **gymwalker** » Fri 18 May 2007 16:38

I did as you suggested and installed the 9.2 Oracle Client...it took a little to get it to work with the components...but now everything is working GREAT...no more Data Type errors!

Thank you so much for your help!

Jim

Devart Forums