Import DDL from Oracle 9.2

[feltzj]

I am trying to import the ddl from an Oracle 9.2 database.  I am using verion 9.02 of the Oracle ODBC driver from Oracle.  I am using version 3.10.500 of EA.  Unfortunately it does not list my tables in the Select Table To Import window.  Is this version of Oracle not supported yet in EA?  

[feltzj]

I tried the Microsoft driver and it allowed me to import the table ddl.  The only problem was that it made any data types of BLOB, or CLOB into VARCHAR.  I had to edit the table in my diagram after the import to correct.

[sparks]

Hello,

We have not tested EA with the version of Oracle you have mentioned, in theory all Oracle ODBC driver should work the same, however this is not the case.  My guess would be the internal name of the Oracle driver has changed and therefore EA cannot recognise the fact that it is an Oracle driver.  

We have written a small tester program that uses the same methods as EA does to read this internal name.  I would like to send you this program and get you to run it on your machine and send us the results.  Could you send us a note to  [email protected]  and we will forward you a copy of the tester program.


Paul Mathers