Enterprise Architect supports many databases, to store it’s models to.
Oracle is one of them.
And many companies use Oracle’s default drivers named OraOleDb.
So do I. But lately I experienced a strange behavior:
select * from t_object
didn’t deliver all the values, I would have expected. Instead, some values from column pdata3 were missing. But
select * from t_object order by OBJECT_ID
What was the difference? I used the ODAC drivers 18.104.22.168 which are known for having problems with BLOB and CLOB fields.
What was the solution: update the drivers to at least revision 2, and the simple select won’t miss any values any more.