If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Reverse Engineer results in incorrect default values for table col
I have been able to reverse an Oracle 10G database using the ODBC Generic
driver. However I have come across a situation where error are reported like the following "TMS ALL 08-07-23.VSD : error L2201: 'TM_ADDR.ADDR_STATUS' : The default value is incompatible with the data type or is too long." When I check the column I find that it has a default value of '18' for a Varchar2(1) column. I'm not sure how the incorrect default vale was captured as when I check the database that is the source, there is no default value. Has anyone else experienced this or know how to prevent it from happening? |
#2
|
|||
|
|||
Reverse Engineer results in incorrect default values for table col
Additional Information.
The default value that is assigned is the column Id within the Oracle database. "Peter Hattam" wrote: I have been able to reverse an Oracle 10G database using the ODBC Generic driver. However I have come across a situation where error are reported like the following "TMS ALL 08-07-23.VSD : error L2201: 'TM_ADDR.ADDR_STATUS' : The default value is incompatible with the data type or is too long." When I check the column I find that it has a default value of '18' for a Varchar2(1) column. I'm not sure how the incorrect default vale was captured as when I check the database that is the source, there is no default value. Has anyone else experienced this or know how to prevent it from happening? |
Thread Tools | |
Display Modes | |
|
|