Sparx Systems Forum

Enterprise Architect => Suggestions and Requests => Topic started by: vitmatejka on March 24, 2005, 05:29:07 am

Title: Import DDL schema from ODBC (Oracle 8.1.7)
Post by: vitmatejka on March 24, 2005, 05:29:07 am

I recieve warning from EA with message from ODBC driver:  
ORA 00904: "invalid column name" even if all columns are imported OK?  
It seems I have to close warning window for every colum in the table.  
I use Oracle 8.1.7 database and the warning apears for both Microsoft ODBC driver for Oracle and original Oracle ODBC driver. EA is running on Windows XP.
What is wrong?

Thank you,
Vit Matejka.

Title: Re: Import DDL schema from ODBC (Oracle 8.1.7)
Post by: Gary W. on March 31, 2005, 09:04:09 am

Hi,

Did you ever solve this?  I recently reverse engineered a 9i (and 10g) DB schema, and it completed without such an error message.

Is there anything special about your column names?  Did you create the tables/columns in Oracle with double quotes around the names?

Cheers,
Gary

Title: Re: Import DDL schema from ODBC (Oracle 8.1.7)
Post by: vitmatejka on March 31, 2005, 09:35:18 am

Hi,
there is nothing special in column names. We made the test with 9i and it passed OK. I think the Oracle 8.1.7 is unsupported version and it probably has a bit different catalogue of columns, constraints ... (?).
But if this problem could be resolved I woudl be glad.

Vit Matejka

Title: Re: Import DDL schema from ODBC (Oracle 8.1.7)
Post by: Jeff Odell on April 19, 2005, 04:06:23 am

I just did some reverse engineering from an Oracle 8.1.7 database and experienced the same problem.  I had to accept the dialog box repeated upon reverse engineering.  EA seemed to reverse engineer the tables OK if I was patient enough to hit the OK button repeatedly.  I have not identified what was missing.

I would be nice to remove this dialog and replace it with something more descriptive and something that an action could be taken against.