Oracle to Access: Text datatype problem

[RobVen]

Hello,

I tried to "Reset DBMS options" to change my package from DBMS Oracle to MsAccess.

Many oracle tables included fields of datatype TEXT(2000).

After using "Reset DBMS options" to change from DBMS Oracle to DBMS MsAccess the datatype stays TEXT(2000) whereas in MS Access text fields can have a maximum size of 255.

So the datatype conversion should be from Oracle TEXT(2000) to MS Access Memo, I think.

Using EA 6.0 Corporate Edition Build 781.

Is this a bug or is there a solution existing? What to do?

Thanks,
Robert

[Oliver Michalski]

Hi Robert,

i think it is a bug. You must change the data type manually.

Oliver  

[RobVen]

Thanks for your quick response, Oliver!

Is there any possibility to automate changes, that usually have to be done manually
(like the one to change the datatype from i.e. TEXT(2000) to Memo in all tables of a package)?

Or is it possible to change the behaviour of the "Reset DBMS option" for certain switches of DBMSs to automatically change i.e. from datatype TEXT(2000) to Memo?

TIA,
Robert

Hi Robert,

i think it is a bug. You must change the data type manually.

Oliver